Thread: Reverse Pivot-type Data (that's not a pivot table)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
  
Posts: 1,670
Default Reverse Pivot-type Data (that's not a pivot table)
Data is not in an actual pivot table (so it can't be reversed to get what I
want), it's just entered in a crosstab format:

June July August
Andy 2 3 4
Dave 3 6 2

Any easy way to convert it to this format?

Name Month Sales
Andy June 2
Andy July 3
Andy August 4
Dave June 3
Dave July 6
Dave August 2

TIA.
Reply With QuoteReply With Quote