how to make a new column and combine names

[Steg]

I have a table with names of employees. There are several names of persons in the list that refers to the same persons, but are written diverently (at least  on incorrect) (column 1). how can I make a new column (column 2) where I combine the right and wrong names. 

column 1		column 2
smith	has to be	smith
cooper	has to be	cooper
meyer	has to be	meyer
meijer	has to be	meyer

[v-kelly-msft · Accepted solution]

Hi @Steg ,

Suppose that you have a table with the correct names:

Then go to power query>click "merge queries as new" under Home button:

Then check "Using fuzzy matching" with a similarity of 0.5(You can set a higher similarity if needed):

And you will see:

You could also check the reference below:

https://radacad.com/fuzzy-matching-in-power-bi-and-power-query-match-based-on-similarity-threshold

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Steg]

This is extremely helpful. thank you so much