Remove duplicates from Recent Alumni spreadsheet

[sandbergja]

What maintenance needs to be done?

Remove any rows that are complete duplicates of one another (i.e. the only differences are in the ID number, created_at, and updated_at columns).

For example, the row with id number 248530 is a duplicate of the row with id number 252493, so one of them should be removed. The names, year, pubfile, and academicfile columns are exactly the same.

Level of urgency

• [ ] High
• [x] Moderate
• [ ] Low

Why is this maintenance needed?

• Better user experience without duplicates
• Maybe it will be a little faster to load

Acceptance criteria

• [x] If two rows have the same lname, fname, year, pubfile, and academicfile, one of them is removed
• [x] If even one of these columns is different between the two rows, they are not deleted.

[sandbergja]

Duplicates removed with the Google Sheets Remove Duplicates feature, which removed just over 9000 duplicate rows.