Consolidating similar rows with unique columns

Hello,

I need help creating a macro that will consolidate similar rows into one single row. I am attaching an example of the raw data on one tab, and the data I would like to have on another tab.

My raw data includes the following columns that need to be the same when comparing rows:
Last Name
First Name
MI
Address
City
State
ZIP
Email
Home Phone
Cell Phone

The "Number" column (first column) does not have to be considered when looking for similarities.

The following columns will only appear once (or not at all) for each individual included in the spreadsheet:
50 FS
100 FS
200 FS
500 FS
1000 FS
1650 FS
100 FL
200 FL
100 BK
200 BK
100 BR
200 BR
200 IM
400 IM

My goal is to combine individuals that appear more than once into one single row with all of their their times (numbers included under 50 FS, 100 FS, etc) combined under that same row.

Thank you for taking the time to consider my problem!

Fernando