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.