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

I think what I need is actually very similar to the question on the following thread: http://www.excelforum.com/excel-gene...e-columns.html

On the link you attached the code used "Dictionary Object" unfortunately dictionary object will not work with this Mac. Not strictly true though, it works, but few people know how to code this object on Mac.

That worked out perfectly, kalak. Thank you! I actually only tried the first formula and it did what I needed. The other sorting macro that stanleydgromjr helped me with a few years ago is still very useful, so I just run that first.

Again, thank you for your help!

Thanks for the feedback.