Excel Tool

Order Online
Our company contact information There you can find frequently asked questions and answers

Home | Products |Purchase | FAQ | Contact Us | Useful Resources

Merge 2 Tables by matching data

If your work is to merge matching rows from 2 tables into 1, you can forget about the complicated Excel vlookup, math, index functions and writing complex formulas for the new tables each time. Now you can merge data from two tables in seconds using a smart 4-step wizard.

Merge Excel Tables by Matching Data


Tool location: Add-Ins →Excel Tool Box → Merge 2 Tables by Matching Data: Shortcuts: (Alt + X + X + T)

The sample table: merge 2 tables by matching data.xlsx

Merge Excel Tables by Matching Data

 

Select the first table:Table1

Before you start Merge Tables Wizard, select a cell in your Table1 and the whole table will be selected automatically.

Merge Excel Tables by Matching Data

Open the Merge 2 Tables by Matching Data pane by clicking on: Add-Ins →Excel Tool Box → Merge 2 Tables by Matching Data or pressing the Shortcuts: (Alt + X + X + T ).

Merge Excel Tables by Matching Data

Click the Next > button:

Merge Excel Tables by Matching Data

Select the second table: Table2

You can select it by clicking the select Range icon

Merge Excel Tables by Matching Data

Select a cell in your Table2 and the whole table will be selected automatically.

Merge Excel Tables by Matching Data

Click the Select Table2 button:

Merge Excel Tables by Matching Data

Click the Next > button:

Merge Excel Tables by Matching Data

Select matching columns, Click 'Add Column' button, You can select more matching columns:

Merge Excel Tables by Matching Data

Click the Next > button:

Please select a matching pattern:

1. Show All Rows from Table1, Show Matching Rows from Table2

Merge Excel Tables by Matching Data

2. Show Matching Rows from Table1, Show Matching Rows from Table2

Merge Excel Tables by Matching Data

3. Show Matching Rows from Table1, Show All Rows from Table2

Merge Excel Tables by Matching Data

4.Show All Rows from Table1, Show All Rows from Table2

Merge Excel Tables by Matching Data

Click the Finish button: File merge completed!

1.Another method of achieving

2.Another method of achieving

Copyright © 2001-2014 Excel-Tool All Rights Reserved.

Copyright Excel-Tool All rights reserved