To clean up the messy data, it needs to be loaded into the Power Query Editor.
How to create and populate a table in Microsoft Excel’s Power Query Your email has been sent Updating data in a Microsoft Excel workbook is common, but you will run into cases where you can replace ...