To clean up the messy data, it needs to be loaded into the Power Query Editor.
If you have worked with the Excel Online connector in Power Automate then you will most likely know the pains of this ...