I want to translate a column to english for comparison in Power query. I dont want to make a change in the excel sheet. For example:
I have this data:
Here the data is in 3 languages: English, French and Spanish. I would like to convert the column "Type" in english so that I can compare this data to add various checks using a power query. I dont want to hard-code.