Ever need to cluster or group text values in Excel quickly? It can be done! In this video I demonstrate how to do this using the Table.FuzzyGroup method in Excel's Power Query editor.
We will work with a data set of job titles, which are notoriously non-standardized. Often times the same job title appears in many different ways, with misspellings or other variations, and we don't want to look at each individual job title itself but rather group them into similar buckets.
My GitHub link below has the example Excel file that I created in this tutorial that you can download and play around with.
https://github.com/michaelgcortes/text-clustering-in-excel