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

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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