Power QueryExercises

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