You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together. Let us understand this using an example. As shown in the below picture, you have two sales data for the year 2015 and 2016. We want to combine these two data tables together.
Append Queries With Power Query
Step 1: Append Queries as New
To combine the above data tables, you need to use Append Queries feature. To use this feature click on-
Home > Combine > Append Queries > Append Queries as New
Step 2: Choose Tables for Appending
When you click on Append Queries as New option, an Append window gets open that allows you to choose the data tables from Power Query. First, you need to specify how many tables you want to append. Then choose the tables and click OK as shown in the below picture.
Step 3: Close & Apply
After you get the desired output as shown in the below picture, you can click on the Close & Apply button.
You can learn more :
- Steps to Format Columns Using Power Query
- Top 5 Steps to Extract Age Using Date in Power Query
- Read How to Merge Columns in Excel
- How to Rename A Column in Excel