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