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