| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View Pivot Table Source data as a Data Table | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| How can I list every data combination from a large pivot table? | Excel Discussion (Misc queries) | |||
| using selected data from a pivot table to populate new list | Excel Programming | |||
| How to create a data list from a pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
