Combine multiple queries (Power Query)

In Power Query you can transform data in a query, but you can also combine queries in two ways:

Merge     Creates a new query from two queries in a join operation. The first query is a primary table and the second query is a related table. The related table contains all rows that match each row from a common column value in the primary table.



For more information, see Merge queries.

Append    Creates a new query that contains all rows from a first query followed by all rows from a second query. You can create an Intermediate Append, which creates a new query for each append operation. Or you can create an Inline Append, which appends data to a  query until you reach a final result.

For more information, see Append queries.