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.

Getting Started

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.

Getting Started

For more information, see Append queries.

See Also

Power Query for Excel Help

Learn to combine multiple data sources (Power Query)

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!