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

Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets. If you’re developing a spreadsheet that ...