To clean up the messy data, it needs to be loaded into the Power Query Editor.
Microsoft Copilot for Excel creates a separate check tab that checks row counts per source, helping you spot missing or extra ...