To clean up the messy data, it needs to be loaded into the Power Query Editor.

Tools like Excel and Google Sheets are ubiquitous these days, and learning how to use them more effectively will quickly enhance your daily work. Alas, spreadsheets aren't always the easiest thing to ...