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
Pivot Table - sourced from another Pivot Table 1
Transform matrix data ("Pivot Table like data") to simple dataset 2
How to base a pivot table on another pivot table? 3
Excel 2007 - Create Pivot table from another pivot table 6
Pivot Table Wizard in Excel 2007 6
Excel 2010 Slicer Connection / Pivot Table Problem 3
Pivot Tables in Excel 2007 1

Top