tools

wizards

step by step

faq

download

MExcel

..:: Merging tables

Wizard strengths and weaknesses... ::..

Strengths

  • Merging by multiple key columns
  • Merging horizontal and vertical
  • Adding non merged data
  • Data type insensitivity (You can merge text and numbers)
  • Simplicity - you don't need any deep knowledge. Everything is done by simple wizard
  • Speed - On large tables (500.000 rows or more) it is 10-20x faster then using combination of functions (VLOOKUP, INDEX, MATCH...)
  • Low CPU usage, which means that you can use other programs while merging large Excel tables!

Weaknesses

  • The only weakness is the fact that the wizard is not a part of Excel and you have to install it. But the instalation proces is easy and fast!