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.