Combine multiple queries (Power Query)

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

Power Query provides an intuitive user interface for combining multiple queries within your Excel workbook by merging or appending them. The Merge and Append operations are performed on any Power Query with a tabular shape that is independent of the data source that the data comes from. For procedural steps describing how to combine multiple queries, see the Combine data from multiple data sources tutorial.

Getting Started

Getting Started

Expand your skills
Explore training
Get new features first
Join Office Insiders

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.

×