Hi,

I want to transform some records from

x name a
x name b
x name c
y nme2 a
y nme2 b

to

x name a,b,c
y nme2 a,b

Is there a way to use SQL to do this?