DSXchange

Posted: **Mon Apr 30, 2012 11:36 am**

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

Posted: **Mon Apr 30, 2012 4:01 pm**

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

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

columns switch to rows with no duplicates