I didn't realize how much time I spent on cleanups until regex let me stop.

There is a common mistake that people who have learned Power Query tend to make: trying to do everything with Power Query. Power Query is not a panacea. It is important to understand what it excels at ...

Fuzzy merge is a smart data preparation feature you can use to apply fuzzy matching algorithms when comparing columns. These algorithms try to find matches across the tables that are being merged.