User Profile
Ksyokz23
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Clean up Similar Location/US State column in Power Query
I have a request to clean up the messy Location column, (NV Central, Nevada Region, Nevada or NV) should fall under Nevada and the Medical Centers should fall under Nevada when you apply the Filter. What will be the best Power Query approach to have only one format for the state = Nevada and have the Medical Centers locations fall under the Nevada State when you apply the filter. Diagram below shows the Location Column that needs to be cleaned up. Keep in mind I have no access to the Data Source. Before Thank you in Advance
