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