How to Merge 2 Microsoft Excel tables?
Step 1 - Select your Main table (Master Table).
Select the Main table to which matching data will be copied.

Tip: Before you run the Merge Tables Wizard, just select a cell of your main table, and the whole table will be selected automatically.
Step 2 - Select a Second table (Lookup table).
Select the Lookup table in which matching data will be searched (looked up).

If the Lookup table is not in same worksheet, first select the spreadsheet you need from the opened workbooks tree.
Step 3 - Select matching columns.
In the dialog box you see the list of columns from the Main table.

Once you check a column from the Main table, you will see a pop-up menu from which you will select a matching column of the Second table.
Tip: Columns with the same names are selected automatically.
Step 4 - Select the action for matching data.
In the dialog box, you see a list of columns from the Second table (Lookup table).

Check a column, and select the action for it:
- Add to the end of the Main table.
- update values in the selected column of the Main table. Updated values will be highlighted in color (you can choose the color from the pop-up in the top-right corner.
If you check the "Insert the column with update status" checkbox in the top-left corner, the add-in adds "Updated" column to your Main table. In this column, updated rows will marked "TRUE", non-updated - "FALSE".
AMerge Tables Wizard for Microsoft Excel
For example, suppose you have 2 Microsoft Excel tables (lists) - "Orders" and "Prices", they both have a column "Product ID". You want to add a correct price and product description from the second table (lookup table) to you main table. Free to try it.
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.
Tags:Merge Microsoft Excel tables, Microsoft Excel



