rows into columns

samba · Post by **samba** » 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

chulett · Post by **chulett** » Fri Oct 13, 2006 2:37 pm

Actually, based on your example you need to do the opposite - columns into rows. Which means you can use the Pivot stage to do that for you.

samsuf2002 · Post by **samsuf2002** » Fri Oct 13, 2006 2:53 pm

do a search on "Pivot" u will find bunch of posts discussed on this topic

samba · Post by **samba** » Fri Oct 13, 2006 3:57 pm

Thanks guys........for your help i got the result what i am expecting..