I have two excel .csv files that have a single numerical field in common, FIELD_A.
What I'd like to be able to do is to leverage this common field in order to merge data between the two, so that I have a single file that contains a row of data that includes data from both .csv files.
i.e.
file_1.csv:
FIELD A | FIELD B
1 | foo
merges with
file_2.csv:
FIELD A | FIELD C
1 | bar
to result in
merged_file.xls:
FIELD A | FIELD B | FIELD C
1 | foo | bar
Is there a way to use excel to do this sort of thing?