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