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

Content

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

Related videos

11 Rules for clean data

Multiple headers data clean up