Unpivoting a worksheet

B

bvdahl

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
 
T

trip_to_tokyo

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.
 
B

bvdahl

Are you trying to be funny...?

trip_to_tokyo said:
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.
Click to expand...
 
R

Reg

I cant see anything in the article which would NOT work on 2007 - where are
you having problems with it?

Reg Migrant
 
B

bvdahl

Well, there is no 'Multiple consolidation ranges' otion in the PivotTable
dialog box

Baard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Unpivot Technique" - Changing a Table Into A List 1
Displaying date in filter criteria 2
How to perform "Reverse pivot table method" in Excel 2007 2
rearange table 1
Excel 2002 - options dialog box missing 1
Cannot find "Plot empty cells as" option in 2007 8
copy and paste with multiple selections in Microsoft Excel 1
Adding text to email body 1

Top