Thread: How to create a data list from a pivot table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default How to create a data list from a pivot table
To reorganize the data, you may be able to use the "unpivot' technique
described by John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm


Nilhan wrote:
I have a matrix table similar to a pivot table. Now I would like to create
the source data list from that table (just the reverse of creating a pivot
table). How would I do that ?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote