columns switch to rows with no duplicates

[ravi7487]

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

[ray.wurlod]

What's difficult about it? What have you tried?

Search the forum for "vertical pivot" and adapt one of the techniques.