Replace values

[Syndicate_Admin]

I have a column with the name of cities, but these are written differently, that is, there are grammatical errors. I need to be able to make a filter where I can select multiple city fields and replace them with the correct name.

Example annex for better illustration

Current Correct

Bogota	Bogota
boogota	Bogota
Bogotta	Bogota
Boogotsa	Bogota

Logically there are many more misspelled cities and I need to normalize the column with the correct values. How do I do this in Power Query? Thank you

[Samarth_18]

Hi @Syndicate_Admin ,

You could use Table.AddFuzzyClusterColumn() 

[Syndicate_Admin]

Thank you very much for the answer, however, this solution would serve me in the case that I previously knew how the city is written, but I do not know that until I make the filter and be able to select the ones I want to change.

Therefore what I require is that once I have selected the rows that contain the value I need through a filter, to be able to change them to the value I need, Thank you