To clean up the messy data, it needs to be loaded into the Power Query Editor.
The privacy-focused Proton Sheets tool is designed to compete with Google Sheets and Microsoft Excel.