What is the best way to join/merge two tables by column cell matching in Excel?
- by blunders
I've found this excel add-in to buy that appears to do what I need, but I'd rather have code that's open to use as I wish. While a GUI is nice, it's not required.
In an attempt to make the question more clear, I'm adding some two sample "input" tables in tab delimited form, and the resulting output table:
SAMPLE_INPUT_TABLE_01
NAME<tab>Location
John<tab>US
Mike<tab>CN
Tom<tab>CA
Sue<tab>RU
SAMPLE_INPUT_TABLE_02
NAME<tab>Age
John<tab>18
Mike<tab>36
Tom<tab>54
Mary<tab>18
SAMPLE_OUTPUT_TABLE_02
NAME<tab>Age<Location>
John<tab>18<tab>US
Mike<tab>36<tab>CN
Tom<tab>54<tab>CA
Sue<tab>""<tab>RU
Mary<tab>18<tab>""
If it matters, I'm using Office 2010 on Windows 7.