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.
Bookmarks