Rearrange Spreadsheet Data using Excel or Python

Hundreds of people's names are in my spreadsheet, and each name has other information with it. The problem is that it's spread across multiple rows and multiple columns on each of those rows. I want it all on a single row per person. The current spreadsheet: Mickey Mouse Address City State Zip Phone Email Income Job title Spouse Favorite Food Homer Simpson Address City State Zip Phone Email Income Job title Spouse Favorite Food What I need: each person and all their info on a single row! Mickey Mouse Address City State Zip Phone Email Income Job Title Spouse Home Simpson Address City State Zip Phone Email Income Job Title Spouse Furthermore, once you do this for one spreadsheet, I need you to tell me how you did it so that I can do it in the future. Thank you! Once I hire you I'll give you the actual spreadsheet, although it will be FAKE DATA. No personal information or identities will be included. I need this done using either Excel, or Python, but please show me how you did it. That's the important part.