Append
Stacking rows of two or more tables into one, matching columns by name.
Columns with the same name line up; a column that exists in only one table is filled with null for the other table's rows. Appending is the right tool for the same kind of data from several periods, regions or files. To add columns from another table, merge instead.
In the Power Query editor
Home → Append Queries (or Append Queries as New), which writes Table.Combine.
Learn more
Related functions
Practise it
- beginner~6 minPro
Stack two months of orders (kite shop)
Append February's orders below January's to get one table.
- intermediate~9 minPro
Append store and web sales with different column names (bookshop)
Align WebSales column names to StoreSales before appending, and see where nulls come from.
- beginner~7 minPro
Append three store tables and label each row's store (kite shop)
Each store sends its own orders table. Stack all three and add a Store column saying where each row came from.
- intermediate~8 minPro
Append tables whose columns differ in order and set (kite shop)
Web orders have a Discount column, phone orders a Channel column, and their columns are in different orders. Append by name.