Combine data from different sourcesMerge Tables Wizard
We created the Merge Tables Wizard to deal with one of the most grueling and time consuming tasks in Excel: combining data from different sources. Until you try it you probably won't believe that finding and merging data from two Excel worksheets can be done literally in seconds.
Data from 2 tables are merged perfectly without copying and pasting!
The Merge Tables wizard swiftly finds and copies matching rows from one Excel table to another based on one or several common columns. You can choose to:
- Update data in existing columns.
- Add new columns to the main table.
- Add non-matching rows to the end of the table.
- Color updated rows for easy analysis.
Customer says: It does exactly what I need
Thank you so much for making this add-in for Excel. It does exactly what you say it should do, on my 10,250 item database. Awesome! Nannette DiMascio More customer stories ...
