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
Quote:
Originally Posted by Sam
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
|