Hi. I have an excel file with 2000 rows and another excel file with 400 rows. I want to add the the second file to the first one at the row that have the matching names. please find example below. I would greatly appriciate the help.Thank you in advance!
tabel 1:
name category1 category 2 ….
112 yes no
888 no yes
986 yes yes
664 no no
table 2:
name result1 result2 …..
743 yes no
112 yes yes
664 no yes
note: the two tables have row name '112' and '664' in common. I want to add data to those row names! and leave the rows that dont match blank.
desired resulting tabel:
name category1 category 2…. result1 result2 ….
112 yes no yes yes
888 no yes
986 yes yes
664 no no no yes
Best Answer