Renaming value if it has similar text in the string (Fuzzy Grouping)

Question

I'm trying to use Power Query to detect similar text in a column and rename any columns with additional text or characters in to a stripped down version of the same text. Is it possible to do this without the use of a reference column in another table?

Example below, the column on the left is the mixed array of names, the column on the right is what I'd like for the output to be.

Answer 1

You can use Table.FuzzyGroup() to achieve what you need. It isn't available from the UI in Excel or PowerBI but is available as a function to call.

https://learn.microsoft.com/en-us/powerquery-m/table-fuzzygroup