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!!!
Convert row data into column based on key
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is a vertical pivot. Search for "vertical pivot" - it has been discussed many times.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.