Reverse Pivot

[Ron]

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

 

[Guest]

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

 

[Guest]

Here is the answer > http://j-walk.com/ss/excel/usertips/tip068.htm

 

[Ron]

Thanks Ellen

Here is the answer > http://j-walk.com/ss/excel/usertips/tip068.htm