Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×