Pivot Table from data table (not data LIST)
 

On Saturday, January 3, 2004 8:31:11 AM UTC+11, Debra Dalgleish wrote:
To restructure your data, you may be able to use the "unpivot' technique
described by John Walkenbach:
http://j-walk.com/ss/excel/usertips/tip068.htm


ychu < wrote:
So now the question is that is there an easier way to convert table to
list? And then we can feed it into a pivot table.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi,

I followed this link, but I couldn't find the "Multiple consolidation ranges option" in Excel 2010? What's the best way of unpivot in Excel 2010?

Thanks
Sam

Hi Sam

To call up the Pivot Table & Pivot Chart Wizard in Excel 2010: ALT + D + P
Alternatively add it to the QAT: More commands All Commands Pivot Table & Pivot Chart Wizard Add.

1: Tick the Multiple consolidation ranges Next Create a single page field for me Next Select your data Finish.

2: Then double click the Grand Total cell.

Kevin