Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.

Of course this flow is a very simplified version of the real AI search engines, but it is a good starting point to understand the basic concepts. One benefit is that we can manipulate the search ...