Forum Discussion
Remove Duplicates in a single cell Power Query
See below's image as an example. The output should just say Tom Kinney one time. If there are any duplicate values, separated by the delimiter, they should be removed. Thanks in advanced, Ryan...
Anonymous
Try this custom column from Query Editor.
Replace ColumnName with actual Name of your Column
=Text.Combine (
List.Distinct(
List.Transform (Text.Split([ColumnName],","),each Text.Trim(_))
)
,", ")
Worked like a charm, thanks
