Page 1 of 1

Pivoting

Posted: Tue Mar 11, 2008 11:29 pm
by karthegx
Hi,

I have need clarification to do this scenario,

My input is this.......

Col1 Col2 Col3

1 A RT

1 A PT

I need to have output as this....

Col1 Col2 Col3 Col4

1 A RT PT

Can anyone help on this..

Thanks in Advance.......

Posted: Tue Mar 11, 2008 11:39 pm
by ShaneMuir
Search the forum for "Vertical Pivot".

I think there is an explanation in the FAQ section also

Posted: Wed Mar 12, 2008 12:39 am
by Raghavendra
Do you what is the maximum number of rows that has to be converted into columns?