Thread: Reverse Pivot
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ellen From Application Builders Ellen From Application Builders is offline
external usenet poster
 
Posts: 2
Default Reverse Pivot

Ron, have you gotten any answers? I also need this capability. Ellen

"Ron" wrote:

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