Transpose columns to rows as a sub-group

Microsoft Excel 2007
September 24, 2009 at 14:27:30
Specs: Windows XP
Hi,

I have the following data:

Row 1 __ R1 R2 R3 R4
Row 2 P1 20 __ 20 __
Row 3 P2 __ 20 10 20
Row 4 P3 10 10 10 __
Row 5 P4 __ __ 30 __


I would like to transpose it to:

Row 1 P1 R1 20
Row 2 P1 R2
Row 3 P1 R3 20
Row 4 P1 R4
Row 5 P2 R1
Row 6 P2 R2 20
Row 7 P2 R3 10
Row 8 P2 R4 20
Row 9 P3 R1 10
Row 10 P3 R2 10
Row 11 P3 R3 10
Row 12 P3 R4
Row 13 P4 R1
Row 14 P4 R2
Row 15 P4 R3 30
Row 16 P4 R4

Can you please help on how I could do it in a way that the transposed cells still refer back to original cell values (so when I change the values in the original cell, it's automatically reflected in the transposed cells as well)?

Appreciate a response.


See More: Transpose columns to rows as a sub-group

Report •


#1
September 24, 2009 at 18:03:56
Post this in the Office Software forum on the right of this page

Home Page http://ewen.uuuq.com/


Report •

#2
September 24, 2009 at 19:45:31
Sorry about that. I could not delete the post. Hence, I have reposted this under the office software forum.

Report •

Related Solutions


Ask Question