drtopserv
asked on
transpose columns to rows
Hi,
I would like to do this programatically :
I have this sheet1:
ID CODE1 CODE2
1 111 222
2 666 67
3 321 234
I would like to run code/function/macro whatever to be able to have the result:
ID
1 CODE1 111
1 CODE2 222
2 CODE1 666
2 CODE2 67
3 CODE1 321
3 CODE2 234
I would like to do this programatically :
I have this sheet1:
ID CODE1 CODE2
1 111 222
2 666 67
3 321 234
I would like to run code/function/macro whatever to be able to have the result:
ID
1 CODE1 111
1 CODE2 222
2 CODE1 666
2 CODE2 67
3 CODE1 321
3 CODE2 234
Have you tried Paste>Transpose?
ASKER
appretiate another solution becuase i can`t install power-query at this time , my computer don`t have explorer 9 .
ASKER
Paste>Transpose? will do :
ID CODE1 CODE2
1 111 222
2 666 67
3 321 234
ID 1 2 3
CODE1 111 666 321
CODE2 222 67 234
ID CODE1 CODE2
1 111 222
2 666 67
3 321 234
ID 1 2 3
CODE1 111 666 321
CODE2 222 67 234
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Without code
If your given data starts from A1 on sheet1 then use this formula on A2 Sheet2 and copy it down and across
=INDEX(Sheet1!$1:$1048576, IF(COLUMN( )=2,1,(ROW ()+2)/2),I F(COLUMN() =1,1,IF(MO D(ROW(),2) ,3,2)))
If your given data starts from A1 on sheet1 then use this formula on A2 Sheet2 and copy it down and across
=INDEX(Sheet1!$1:$1048576,
ASKER
BEST OF THE BEST.
THANKS ALOTTT
WORKS AS A CHARM!
THANKS ALOTTT
WORKS AS A CHARM!
you are welcome. i am glad i was able to help.
see the tutorial