Excel row to colum

[Closed]
Report
Posts
1
Registration date
Tuesday September 4, 2012
Status
Member
Last seen
September 4, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i would like a little bit help.

i want from this:

data1 data2 data3
a 120 20120903
b 270 20120903
c 36 20120903
d 45 20120903

now:

code1" code2 code3" code4" code6 code7
code1"a" code2 code3"120" code4"20120903" code6 code7
code1"b" code2 code3"270" code4"20120903" code6 code7
code1"c" code2 code3"36" code4"20120903" code6 code7
code1"d" code2 code3"45" code4"20120903" code6 code7

and i want this:

code1"a"
code2
code3"120"
code4"20120903"
code6
code7

code1"b"
code2
code3"270"
code4"20120903"
code6
code7

code1"c"
code2
code3"36"
code4"20120903"
code6
code7

etc..

pls help.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am not sure if I got you. Could you please re-explain your issue. I did not get your first set of codes and it relates to 2nd. The third seems to be just converting column into row