Data Wrangling with Query Editor

[AlejandroPCar]

Hi! 

I have a tedious problem with some "raw" data here. I have a list of companies names with several differents names for a same companie i.e. A companie named "Muebles S.A." can be found with the following names : "Muebles   S.A." , "muebles s.a." , "Muebles SA." , "MueblesSA." etc. I mean it is the same name but with more spaces beetwen words or a dot at the end or withouth dots in the word so BI understand the name like different even when it is not. 

So... is there a way to use the Query Editor to transform the list and try to unify the names? Or as a plan B is there another software that could do that? 

Thanks for your help.  Have a nice day. 

Alejandro

[Greg_Deckler · Accepted solution]

So, yes, you can replace values in Query Editor, do things like Trim, Clean, Capitalize, etc. Just right click the column in Query Editor and choose Transform for many of these. For the specific case below, if you did a "Capitalize Each Word" and replace "." with "" and spaces with "" then you should get them all into "MueblesSA"