Combining Rows - Keeping Unique and "New" Values & Merging Duplicate Values

I am in need of quite a bit of help. I do not know VBA, and I don't think I'll be able to figure out what I need to do on my own.

I have a huge spreadsheet that is temporarily storing "member" information. I have quite a bit of semi-duplicate data.

Example
123456 | jane.smith@site.com | Jane | Smith | | Single <-- Older Record
258369 | jane.smith@site.net | Jane | Smith | Houston | Married <-- Newer Record

So, I need these rows combined: keeping the duplicate data and updating with the "newer" data (on the bottom row), but keeping the USERID with the smaller number.

Result
123456 | jane.smith@site.net | Jane | Smith | Houston | Married

Is this even possible? I am assuming if it is that I would need VBA code or a macro.
Otherwise, I have to do this all by hand - which is currently 600+ rows of data to fix. Out of 11,000+ rows, it's not horrible, but who wants to do this by hand?

Can anyone help me out?