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

David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.