Combining multiple records (based on name/co)

I am completely new to running macros/VBA functions in Excel. But realize that I HAVE to use one to solve my issue. After much searching on this forum, I have not found the solution to my problem.

I have a compiled list of members that contains over 9000 records each with various amounts of contact information (title, street, city, phone, email, etc.) and also a list of what region, membership year, and conference they attended. I need to combine all duplicates of a person (first and last) and company into just one record with ALL information into one row/record.

Here's an example of the data (not shown: information goes until Column AZ):
Attachment 287361

I realize that in my example that a function will not help merge Tony and Anthony, but it will definitely get me closer if the instances are combined to just two records.

Please help!
Thank you,
jean