What is Merge Query ?

Merge query is a feature of power query which helps us to get data from multiple files based on one or multiple common columns. Merge query works in similar fashion as VLOOKUP in excel but we can do a lot more using this feature. VLOOKUP in excel means Vertical lookup. The function searches for a lookup
value in the left most column of a section in your spreadsheet called the table array.

In Merge query, we can select multiple columns in the same sequence in both the tables and bring all the required columns from one table into another in few clicks.

Merge query also allow us to retain only rows which are matching or not matching either in Table 1 or Table 2. It can be done with the help of joins which can be seen in the below image: