Previous Topic Next Topic

Excel row to colum

Closed
SuTTi
Posts
1
Registration date
Tuesday September 4, 2012
Status
Member
Last seen
September 4, 2012
 - Sep 4, 2012 at 02:42 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Sep 11, 2012 at 05:53 AM
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

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Sep 11, 2012 at 05:53 AM
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
0