Remove duplicates in values (string)

[Anonymous]

Hello, 

I have in a column, values including some duplicates :

Ex :

Input :

ID	Value
ID1	A-B-A-C-A
ID2	A-B
ID3	A-C-C

Expected Output :

ID	Value
ID1	A-B-C
ID2	A-B
ID3	A-C

Thanks in advance for your help

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a custom column in Power Query.

=Text.Combine (
                List.Distinct(
                          List.Transform (Text.Split([Value],"-"),each Text.Trim(_))
                                  )
                     ,"- ")

Best Regards

Community Support Team _ Polly

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

[Greg_Deckler]

@Anonymous Use Text to Table, replace - with | see the first comment below this entry:

Text to Table - Microsoft Power BI Community

Then you can use DISTINCT and CONCATENATEX to recombine with your dashes.