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.
file_1.csv: FIELD A | FIELD B 1 | foo
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?