I have a table with three columns.
Name , city and country. The city names are in codes, I have a mapping for the city codes to their full names.
But since the data has over 10,000 rows and more than 50 different states, it is difficult to do find and replace.
Can you please suggest an alternative to use vba code or any other feasible way to do replace all the codes with the city full names.
Attaching a sample code with the query.
Thank you!
Name , city and country. The city names are in codes, I have a mapping for the city codes to their full names.
But since the data has over 10,000 rows and more than 50 different states, it is difficult to do find and replace.
Can you please suggest an alternative to use vba code or any other feasible way to do replace all the codes with the city full names.
Attaching a sample code with the query.
Thank you!