Excel Data Cleanup: How to Convert Repeating Column Groups to Tabular format using Power Query
Learn how to save hours of manual work using Power Query to clean badly formatted data - usually encountered while copy pasting from reports and web pages. Works with Excel 2010 and beyond.
Dr. Nitin Paranjape (Office MVP)