Merge 2 worksheets by matching values

 

By this feature, you can merge 2 worksheets by matching values. The program matches rows automatically based on the key column, and connect the rows from the two worksheets into one row.

 

 

Steps to go:

Step 1: Specify worksheet1. Clicking this line, the ‘Browse’ button appears on the right side. Clicking the button, you can select a workbook at first, and select a worksheet in it.

Step 2: Specify key column of worksheet1. The application will compare the two worksheets based on their key column.

Step 3: Specify worksheet2 in the same way as Step 1.

Step 4: Specify key column of worksheet2.

Step 5: Enter ‘Keep formulas in the result’. Normally you can select ‘No’.

Step 6: Click ‘Start’ button.

 

Example:

 

Let’s say you have product-sale worksheet and product-price worksheet. Now you want to add price column for the first worksheet.

 

Product	Sale
PC	100
Icebox	30
Car	25

 

Product	Price
VCD Player	300
Icebox	2500
TV Set	3100
Car	250000
PC	5500

 

Follow step 1~6:

Step 1: Specify worksheet1 as the customer list of year 2006.

Step 2: Key column of worksheet1 should be 1 here.

Step 3: Specify worksheet2 as the customer list of year 2005.

Step 4: Key column of worksheet2 is also 1.

Step 5: Click ‘Start’ button.

 

Result:

Product	Sale	Product	Price
PC	100	PC	5500
Icebox	30	Icebox	2500
Car	25	Car	250000

 

As you can see, the program merges the rows that have the same products.