I am trying to do the following:
- Combine two different workbooks that have one column in common which are ID’s number
- Once the bot matches the ID I want it to create a new sheet show all the ID’s that match and the ones that don’t match HOWEVER combine the two ID columns into one single column of ID’s that have all the ones that were a match and not matched
- The new sheet should have all columns that were in the two workbook and their information should match the rows to their respected ID’s
I already used Join Data Tables to create the new excel sheet. I’m just stuck in only having one column of all ID’s matched and not matched. Can anyone please help me?