Site logo white shadow

Merged rows – Data Clean up – Excel Power Query

Learn how to clean up data quickly. Common problem. Tabular data has some intermittent merged rows. Cleaning these manually is time consuming and efficient. Using Power Query this can be done instantly. Next time data changes, just refresh.

Sample File


  1. Create Table – 00:51
  2. Open with Power Query – 01:11
  3. Create a separate Category column – 01:54
  4. Fill gaps in Category column – 02:56
  5. Remove unwanted rows – 03:07
  6. Check data types – 03:35
  7. Import Data – 04:17
  8. Add more data – refresh – 04:46
  9. Summary – 05:04

11 Rules for clean data

Multiple headers data clean up

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,811 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.