| Editor Mechanics |
| Power Query Editor |
Visual interface for shaping data with M-language steps |
| Applied Steps |
Recorded list of transformations replayed at every refresh |
| Column Transformations |
Renaming, splitting, type changes, and calculated columns |
| Row Transformations |
Filtering, removing, sorting, and keeping or removing duplicates |
| Reshaping Operations |
| Merge Queries |
Joining queries on key columns like a SQL join |
| Append Queries |
Stacking queries with the same schema vertically |
| Pivot and Unpivot |
Reshaping wide tables to long, or long tables to wide |
| Group By |
Aggregating rows by category to produce summarised results |