Thread: how to convert the rows into column which has the parent-child relationship

Hi all

I am using excel 2007.My excel sheet looks as follows:

WO AC ACC EO KR
1 7 3 6 4
4 7 3 6 4


The first row are the columns.I need the result as below:

1 7
1 3
1 6
4 4
4 7
4 3
4 6
4 4

The first column is the parent value and the rest are the child.
So the parent value holds the child value.Its something looks like converting row into coulmn but the parent value should be in the FIRSTcolumn and the child value should be in the SECOND column Can anybody help me how to do it? Thanks in advance.

A quick formulae-free cheat is to use a Multi Consolidation Pivot, drill into Grand Total to get transposed output, see attached - on the drill through sheet you can obviously delete 2nd column.

Here is a basic guide to this technique:

http://datapigtechnologies.com/blog/...-a-pivottable/