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