Skip to Content
Oct 09, 2019 at 08:55 AM

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


My expected result would be :

Variable1 Variable2

A 123,456,789

B 12

C 2587,C3541

Thank you in advance