Hi,

I need to find a way to concatenate two different spreadsheets by a
column - I have two spreadsheets with slightly different information,
but with a column that can be used as a key. What I need is to find a
way to collate the information in the two columns, and if a
coincidence is found to transfer some of the cells from the same line
as where the coincidence is found from the first spreadsheet into the
other. Also the lines where there is no coincidence should be removed.
Example :

spreadsheet 1 :

ABV 111
BBB 222
VVV 333
GGG 333
DDD 444
ZZZ 567
OOO 452

Spreadsheet 2 :
AAA 432
DDD 324
BBB 342
VVV 432
OOO 642
ZZZ 7878

The first column is the key, so spreadsheet 3 should be :

BBB 222 342
VVV 333 432
OOO 642 452
ZZZ 567 7878


Thanks in advance !