rows into columns
Posted: Fri Oct 13, 2006 2:10 pm
I need to convert rows into columns.
my scenario like this
item01 item02 item03 item04 mul01 mul02 mul03 mul 04
EA MI LO XE 12 32 23 13
need to like this
sqno item mul
01 EA 12
02 MI 32
03 LO 23
04 XE 13
like that i have to convert 100 rows into columns
Can any please suggest me.
Thanks in advance
my scenario like this
item01 item02 item03 item04 mul01 mul02 mul03 mul 04
EA MI LO XE 12 32 23 13
need to like this
sqno item mul
01 EA 12
02 MI 32
03 LO 23
04 XE 13
like that i have to convert 100 rows into columns
Can any please suggest me.
Thanks in advance