I was wondering how to go about the following:
I have 2 spreadsheets.
They both contain columns for part numbers, along with several other columns that are unique to each spreadsheet.
I would like to compare the two 'part number' columns and bring all the columns of data into another spreadsheet omitting any duplicate part numbers.
I would appreciate any help.
Thank you
I have 2 spreadsheets.
They both contain columns for part numbers, along with several other columns that are unique to each spreadsheet.
I would like to compare the two 'part number' columns and bring all the columns of data into another spreadsheet omitting any duplicate part numbers.
I would appreciate any help.
Thank you