Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 28th 13, 03:24 AM posted to microsoft.public.excel.charting
Sam Sam is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 4
Default 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   Report Post  
Old January 28th 13, 10:23 AM
Member
 
First recorded activity by ExcelBanter: Oct 2012
Posts: 93
Default

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 View Post
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
View Pivot Table Source data as a Data Table InsomniacFolder Excel Discussion (Misc queries) 6 April 12th 10 05:17 PM
Lookup data in a variable table & retrieve data from a pivot table Shawna Excel Worksheet Functions 3 October 10th 08 11:11 PM
How can I list every data combination from a large pivot table? zjjason Excel Discussion (Misc queries) 1 April 26th 08 12:59 AM
using selected data from a pivot table to populate new list Roger on Excel Excel Programming 0 November 16th 07 07:58 PM
How to create a data list from a pivot table Nilhan Excel Discussion (Misc queries) 1 November 8th 06 01:40 AM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017