I have a sheet where the rows contain duplicate column data. I would like to
combine the duplicate rows while combining the individual column data.
Example:

Name Address City State Zip Phone
John Smith 999 Onterio MI 12345
John Smith MI
1234567890
John Smith 999 Onterio 12345
John Smith MI

There are multiple columns and multiple rows in the real content. This is
just an example but this should get the point across.

Any help with this would be greatly appriciated. Thanks!

-EW