How to transpose col values into col names
Posted: Fri Nov 13, 2009 1:18 am
Hi All,
My requirement is like this.
The input is :
Col1 Col2 Col3
Site1 Attr1 1
Site1 Attr2 2
Site1 Attr3 3
The output should be like:
Col1 Attr1 Attr2 Attr3
Site1 1 2 3
The number of values for Col2 in input dataset might change. So it should be dynamic
Your response would be highly appreciated.
Thanks,
Shalini
My requirement is like this.
The input is :
Col1 Col2 Col3
Site1 Attr1 1
Site1 Attr2 2
Site1 Attr3 3
The output should be like:
Col1 Attr1 Attr2 Attr3
Site1 1 2 3
The number of values for Col2 in input dataset might change. So it should be dynamic
Your response would be highly appreciated.
Thanks,
Shalini