Unpivoting a worksheet

[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

 

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

 

[bvdahl]

Are you trying to be funny...?

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.

 

[Gilbert]

Copy the pivot > Paste Special > Values

Are you trying to be funny...?

 

[Reg]

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

Reg Migrant

 

[bvdahl]

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

Baard

 

[Herbert Seidenberg]

Excel 2007
ALT+D+P