Single Cell Duplicates Removal

[HusseinKhalil]

please support with a solution for the below issue, i have column Data as below, i need the result to be as illustarted

Data	Result
1-2-1-3-1	1-2-3
4-1-3-4-5-5	1-3-4-5

[v-xuding-msft]

Hi @HusseinKhalil ,

Does that make sense? If so, please accept the helpful answer as the solution. More people will benefit from this thread. Thanks in advance!

[amitchandak · Accepted solution]

@HusseinKhalil ,

Try like

Text.Combine(List.Sort(List.Distinct(Text.Split([Column1], "-"))), "-")