Convert row data into column based on key
Posted: Fri Jun 26, 2009 12:30 am
Hi ,
I have a reuirement to convert the row data into column based on key.
The data will be like
1|A
1|B
1|C
2|X
3|Y
3|Z
Output should be like :
1|A,B,C
2|X
3|Y,Z
Pls Help!!!
I have a reuirement to convert the row data into column based on key.
The data will be like
1|A
1|B
1|C
2|X
3|Y
3|Z
Output should be like :
1|A,B,C
2|X
3|Y,Z
Pls Help!!!