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.

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 Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.