Courses / Power Query (Get & Transform)
17. Append Queries
Stacking tables vertically by appending queries with matching column sets.
1 min read Chapter 17 of 43
Power Query M
Append Queries
Appending combines (stacks) tables vertically so rows from multiple queries become one table.
"I need to stack monthly reports so they become one long table for analysis."
Appending is the operation of joining tables by rows: it takes multiple tables with similar columns and stacks their rows into a single table, filling missing columns with nulls.
"I need to stack monthly reports so they become one long table for analysis."
Appending is the operation of joining tables by rows: it takes multiple tables with similar columns and stacks their rows into a single table, filling missing columns with nulls.