Hi Team,
we have a difficult scenario. please help us.
Input:
Key colmn1 column2
1 A X
1 A Y
1 B Z
1 B Z
Output :
Key Col1 Col2
1 A,B X,Y,Z
columns switch to rows with no duplicates
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: