Cleaning Excel Data With Power Query Straight to the Point

Table of Contents

1. Introduction
2. First, Some Background for Power Query
3. Getting Data into Power Query
4. Fill Up and Fill Down
5. Parsing Text
6. Sorting in Power Query
7. Merging Data: Joining and Appending
8. Grouping Data
9. Refreshing and Updating Data
10. Adding Columns
11. Unpivoting Data
12. Conclusion