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

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

Reverse Pivot
 

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


"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

Reverse Pivot
 

Thanks Ellen


Ellen From Application Builders wrote:

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


"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