Append queries (Power Query)
In Power Query, the Append operation creates a new query that contains all rows from a first query followed by all rows from a second query.
Perform an Append operation
You can perform two types of append operation: Intermediate Append or Inline Append. With Intermediate Append, you create a new query for each append operation. With Inline Append, you append data into your existing query until you reach a final result. The result is a new step at the end of the current query.
In Query Editor, in the query Preview grid, click the table icon () and click Append Queries....
In the POWER QUERY or Query Editor ribbon, in the Combine group, click Append. When using the Query Editor ribbon, the active query is selected as the primary table for the Append operation.
In the Append dialog box, select the first and second tables (queries) to append.
Once the Append operation completes, Power Query displays a new query in the query editor.