Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
168
Views
Topic starter
Hi, I searched several Excel sites; however, I could not find an answer or video on the "Topic name" above. How do I merge/append/joint two tables with inconsistent employee names to make a Pivot Table? I have two spreadsheets that have a column header named “Employee Name”, and majority of names are inconsistent, i.e., Bidden,Bobby A verse Bidden,Bobby Allen.
Posted : 19/02/2024 7:44 pm
Check out Phil's blog post on fuzzy matching in Power query. I believe that it will guide to the solution you need.
https://www.myonlinetraininghub.com/fuzzy-matching-in-power-query
Posted : 20/02/2024 3:27 am
Topic starter
Ryan,
Hi, it works like a charm. Thank you for providing a solution to my work task!!!
Posted : 20/02/2024 9:14 pm
