Combining two spreadsheets, one has an extra category

Hi, I have two spreadsheets which I would like to combine: spreadsheet 1 is from our client database which includes a client name and the associated department on each row (only for one department, ...