Unpivoting a worksheet

  • Thread starter Thread starter bvdahl
  • Start date Start date
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
 
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.
 
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...
 
I cant see anything in the article which would NOT work on 2007 - where are
you having problems with it?

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

Baard
 
You must log in or register to reply here.

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
rearange table 1
Excel 2002 - options dialog box missing 1
How to perform "Reverse pivot table method" in Excel 2007 2
Cannot find "Plot empty cells as" option in 2007 7
copy and paste with multiple selections in Microsoft Excel 10
autoexpanding two tables 3

Back
Top