Concatenate one column and group by multiple

[theapengelly]

Hey, 

I am trying to reduce the number of rows in my table, by concatenating distinct values in a particular column, but I want to leave all other columns the same.

How would I go from this

Item	Client	Label
244243	1	A
244243	1	B
244243	2	A
244243	2	B
244243	3	A
244243	3	B
244243	4	A
244243	4	B
176222	5	B
176222	6	B

To this:

Item	Client	Label
244243	1	A,B
244243	2	A,B
244243	3	A,B
244243	4	A,B
176222	5	B
176222	6	B

So I just want to concatenate the unique values in the Label column, and group by Item and Client?

Thanks so much!

[theapengelly]

Thank you this worked!

[DataNinja777]

Hi @theapengelly ,

You can produce your required output by writing a ConcatenateX measure like below:

ConcatenateX Label = concatenatex(distinct('Table'[Client Label]),'Table'[Client Label],", ")

The required output is as shown below:

Best regards,

[Smalfly · Accepted solution]

@theapengelly ,

try this:

Table.Group(Source, {"Item", "Client"}, {{"concat", each Text.Combine([Label], ", "), type text}})