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

You gotta build a "digital twin" of the mess you're actually going to deploy into, especially with stuff like mcp (model context protocol) where ai agents are talking to data sources in real-time.