Unpivoting a worksheet
in [General]
|
From: bvdahl on 15 Apr 2010 06:20 Hello, I have tried to search for tips on how to unpivot a worksheet, and it seems that everyone is refering to the article http://j-walk.com/ss/excel/usertips/tip068.htm .. This article, however, does not apply to Excel 2007 which I use. Could anyone please tell me how to do this in Excel 2007? Thx, in advance Baard
From: trip_to_tokyo on 15 Apr 2010 10:44 Highlight all the cells in the Pivot Table. Hit the DEL key. Save the file. Job done! If my comments have helped please hit Yes. Thanks. "bvdahl" wrote: > Hello, > > I have tried to search for tips on how to unpivot a worksheet, and it seems > that everyone is refering to the article > http://j-walk.com/ss/excel/usertips/tip068.htm > . This article, however, does not apply to Excel 2007 which I use. > > Could anyone please tell me how to do this in Excel 2007? > > Thx, in advance > > Baard
From: bvdahl on 15 Apr 2010 11:00 Are you trying to be funny...? "trip_to_tokyo" wrote: > Highlight all the cells in the Pivot Table. > > Hit the DEL key. > > Save the file. > > Job done! > > If my comments have helped please hit Yes. > > Thanks. > > "bvdahl" wrote: > > > Hello, > > > > I have tried to search for tips on how to unpivot a worksheet, and it seems > > that everyone is refering to the article > > http://j-walk.com/ss/excel/usertips/tip068.htm > > . This article, however, does not apply to Excel 2007 which I use. > > > > Could anyone please tell me how to do this in Excel 2007? > > > > Thx, in advance > > > > Baard
From: Gilbert on 15 Apr 2010 11:09 Copy the pivot > Paste Special > Values "bvdahl" wrote: > Are you trying to be funny...? > > "trip_to_tokyo" wrote: > > > Highlight all the cells in the Pivot Table. > > > > Hit the DEL key. > > > > Save the file. > > > > Job done! > > > > If my comments have helped please hit Yes. > > > > Thanks. > > > > "bvdahl" wrote: > > > > > Hello, > > > > > > I have tried to search for tips on how to unpivot a worksheet, and it seems > > > that everyone is refering to the article > > > http://j-walk.com/ss/excel/usertips/tip068.htm > > > . This article, however, does not apply to Excel 2007 which I use. > > > > > > Could anyone please tell me how to do this in Excel 2007? > > > > > > Thx, in advance > > > > > > Baard
From: Reg on 15 Apr 2010 11:22
I cant see anything in the article which would NOT work on 2007 - where are you having problems with it? Reg Migrant "bvdahl" wrote: > Hello, > > I have tried to search for tips on how to unpivot a worksheet, and it seems > that everyone is refering to the article > http://j-walk.com/ss/excel/usertips/tip068.htm > . This article, however, does not apply to Excel 2007 which I use. > > Could anyone please tell me how to do this in Excel 2007? > > Thx, in advance > > Baard |