WEBI Tranpose + Concatenate

Hi all

So i am having a hard time to get this solved..

I need to transpose + concatenate one column

My query result are two columns with multiple records variable2 per variable1 (ending up with multiple records per variable1).

Something like:

Variable1 Variable2

A 123

A 456

A 789

B 12

C 2587

C3541

My expected result would be :

Variable1 Variable2

A 123,456,789

B 12

C 2587,C3541

Thank you in advance