I am looking to create an aggregated / consolidated table with unique rows based on a table with multiple rows for the same dimension

[sashak]

I am looking to create a table with unique rows, where values in one column, are concatenated into a string with the comma separator. See screenshots for reference.

Original table: 

Account	Account Manager
Agency 1	Jane Smith
Agency 1	John Baker
Agency 1	Jason Green
Agency 1	Catherine Blake
Agency 5	Jessica Carter
Agency 6	Keven Wiess

Table to create:

Account	Account Manager
Agency 1	Jane Smith, John Baker, Jason Green, Catherine Blake
Agency 5	Jessica Carter
Agency 6	Keven Wiess

Appreciate any suggestions.

[seanbruton · Accepted solution]

Hi,

Please try this. Make your Account Manager Column a measure and use concat function with a distinct.

concat(distinct [Account Manager],',’ )

Regards

Sean

[sashak]

Thank you, @seanbruton ! That worked.

[seanbruton]

@sashak I am happy it's resolved. Please could you mark the correct answer as the solution.