Thread: Reverse Pivot
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron[_35_] Ron[_35_] is offline
external usenet poster
 
Posts: 2
Default Reverse Pivot

I would like to takes what is essentially a summary table like a pivot
and turn it back into a list

For example

Activity-1 Activity-2
Task-1 1 2
Task-2 3 4


I want to turn it into a new worksheet


Task-1 Activity-1 1
Task-1 Activity-2 2
Task-2 Activity-1 3
Task-2 Activity-2 4

Your assistance would be appreciated

Ron