How to perform "Reverse pivot table method" in Excel 2007

I

Ivan

Hello,

on the J. Walkenbach's page
http://www.j-walk.com/ss/excel/usertips/tip068.htm you can see the Joel
Horowitz's method of transforming the matrix data back to the dataset
table. Although this method is somehow the inverse of "pivot table method",
this transformation also uses the "pivot table method" as part of this
conversion.

I didn't have any problem to perform this metod using the past versions of
excel but there is a problem with use of Excel 2007 and its Pivot Table
Wizard. This wizard simply don't have the parameters (or only I didn't find
them) required to perform the Horowitz's method.

Does anybody have a solution or a hint?

Ivan
 
D

Debra Dalgleish

You could press Alt-D, then P, to open the old PivotTable Wizard.
Then use the Multiple Consolidation option to unpivot the data.
 
M

msnews.microsoft.com

Thank you Debra

Ivan

Debra Dalgleish said:
You could press Alt-D, then P, to open the old PivotTable Wizard.
Then use the Multiple Consolidation option to unpivot the data.
Click to expand...
 

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

Pivot Tables in Excel 2007 vs 2003 1
Transform matrix data ("Pivot Table like data") to simple dataset 2
How to set default calculation method in pivot tables? 2
Pivot Table Wizard in Excel 2007 6
Excel 2003 Pivot Table in Excel 2007 3
Excel 2007 pivot table source table 1
Adding a pivot table in Excel 2007 from a QUERY in Access 2007 4
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top