How to join 2 tables with a common column in Excel 2003

[blyssz]

Hello all,

I have 2 tables in excel:
Table 1: Column A and Column B
Table 2 Column A and Column C
I want to join Table 1 and Table 2 to get Table 3 with columns A, B and C
Now, It is possible that some of the values in column A might be same in Table 1 and Table 2 .
How can I merge 2 tables In excel 2003 and can remove duplicate values.
Any suggestion will be much appreciated.

Thanks,
Blyssz

 

[SkipVought]

Hi,

Use MS Query. faq68-5829.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}