Unpivoting a worksheet
 

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

Unpivoting a worksheet
 

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

Unpivoting a worksheet
 

Are you trying to be funny...?

"trip_to_tokyo" wrote:

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

Unpivoting a worksheet
 

Copy the pivot Paste Special Values

"bvdahl" wrote:

Are you trying to be funny...?

"trip_to_tokyo" wrote:

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

Unpivoting a worksheet
 

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

Unpivoting a worksheet
 

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

Unpivoting a worksheet
 

Excel 2007
ALT+D+P