Merge tables

 

Use this valuable tool to merge two databases based on a common field.
You will find the following example very useful to understand how this tool operates.
Consider the tables below, they are the databases we are going to work with.

 

Click on the Consolidate Tables button. The dialog shown below will appear.

 
1. Enter the range containing each database.
2. We have to choose the cell containing the name of the field common to both databases.
 
In the figure below, we have chosen the D2 cell, as it contains the name of the common field.
 

Then, choose the upper left cell from which we want pasted results to start.

Finally, click on the Do It button in the dialog and the action will take place.
The result is shown in the image below.