HELP! Consolidating data in spreadsheet without data loss

I have a dataset that I'm trying to consolidate into unique records without losing any data.  Each observation has an SSID number, and there are duplicate entries in the SSID number column.  I don't want to de-dupe the records using Excel's de-duplicate, because there is information across multiple rows/columns that I would like to consolidate.

Here's an example (with fake IDs to preserve confidential information):

My duplicate ID is highlighted with conditional formatting.  I'd like one observation for student #1234, but that preserved both the grade in Column D, and the 'yes' in Column C that appears in the second row for student #1234.

Using Excel's native de-duplicate or consolidate data functions means I lose either the grade in column D or the yes in column C.

Any way to do this?