Remove Duplicates in a single cell Power Query

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(_))
                                  )
                     ,", ")

Seems like a very simple solution but I cannot figure this out for the life of me :smileysad:

Hello, I was able to follow this logic and it worked for me. Thank you so much. I am wondering if it is possible to take it one step further. Instead of simply removing the duplicates - could it display as Tom Kinney x3?