Concatenate values from a column in multiple rows that have the same User ID value in another column

[Anonymous]

Please see the image. I have multiple constituents that have more than one Role. I am hoping to combine those values into one row per person as shown at the bottom of the picture. It could be in a new column if needed. Thanks in advance for your assistance. 

[Anonymous]

@v-jialluo-msft This is perfect! Thank you very much for your help and sharing your knowledge.

[v-jialluo-msft · Accepted solution]

Hi  @Anonymous ,

Please follow these steps:
(1) Create a new measure

CONCAT = CONCATENATEX(FILTER(ALL('Table'),'Table'[User ID]=MAX('Table'[User ID])),[Role],",")

(2)Final output

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[npradhan]

This is awesome. What if I had to match multiple columns in multiple rows?
For eg;
1 unified row  (containing the concatenation you mentioned[POA,POC}) for 2 or more rows having the same values for lets say 3 columns like user id, address, phone.

Thanks in advance!

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result.