I need to compare 2 excel files to match one column and if the column matches create a new excel file with some columns of the first excel and all the columns from the 2nd excel.
So for example;
My 1st excel file, looks like this;
And I want to compare column ‘Organisation’ from excel file 1 to column ‘Organisation’ from excel file 2. Excel file 2 is below;
If they match I want to create a 3rd excel file with all the columns from excel file 2 but also to include column ‘Developer’ and ‘Project Owner’ from excel 1. How can I get the end results as below;