| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unpivoting a worksheet
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unpivoting a worksheet
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unpivoting a worksheet
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unpivoting a worksheet
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unpivoting a worksheet
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unpivoting a worksheet
Well, there is no 'Multiple consolidation ranges' otion in the PivotTable
dialog box Baard "Reg" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unpivoting a worksheet
Excel 2007
ALT+D+P |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Linear Mode
