Remove dublicates from Text.Combine ??

[Anonymous]

Hello, 

I need to remove dublicates from my grouped data. But how?

Thanks in advance

[v-jingzhang]

Hi @Anonymous 

Another way is to filter rows according to Werk column string length after grouping. Duplicated rows have longer strings than others. 

= Table.SelectRows(#"Grouped Rows", each Text.Length([Werk])<=4)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[wdx223_Daniel · Accepted solution]

Text.Combine(List.Distinct([Werk]))

[Thingsclump]

Hi @Anonymous 

Best way is to select column 1 and column 2 before group by and remove duplicates. 

Thanks