Concatenate along with duplication removal

[Junaid11]

Hello,

I am using two custom columns for one query which I feel can be done in one query. So I have the data and I grouped all the data based on ID. The new column was grouped and names as column1. I wanted to concatenate the data for each column if ID was same. I was using below code for the custom column :

Table.Column([column1],"Vendor Description")

Then I extracted the value basaed on comma delimeter

but the problem was if two rows had same id and the concatenation was done based on above column so if there was same values they were showing like below:

I wanted it to show only single value if both values were same and if both values were different values then show the different values so for that I created another custom column below:

Text.Combine( List.Distinct( List.Transform([column1][Vendor Description], Text.Trim)),",")

It was working completely fine. Its resuls look like below:

I want to both the codes below to be merge into single in some way I can get concatenation as well removal of duplicate after the comma.

Table.Column([column1],"Vendor Description")

Text.Combine( List.Distinct( List.Transform([column1][Vendor Description], Text.Trim)),",")

Help would be appreciated.

Thank you

[Greg_Deckler]

@Junaid11 Why not:

Table.Distinct(Table.Column([column1],"Vendor Description"))

[Junaid11]

Hello @Greg_Deckler ,

It is giving below error:

[Greg_Deckler · Accepted solution]

@Junaid11 Oh, right, Table.Column returns a list. How about:

Text.Combine( List.Distinct( List.Transform(Table.Column([column1],"Vendor Description"), Text.Trim)),",")