Move Data from multiple rows to one row

[jessbr]

Hi there,
I'm looking for advice on how to move data from different rows to one row using a formula.
I have spreadsheet that has been exported from Salesforce, with about 1000 rows of data about contacts. Most of the contacts in this spreadsheet repeat a few times in different rows because they have different related information associated with the different rows. There are also different numbers of rows for each contact depending on how many related entries existed for them in Salesforce. Some contacts have 6 rows with different related information, and some have only 1.

for example:
Name Contact ID Related Information
Sally Doe 11111 Goes To school
Sally Doe 11111 Does Extra curricular activities
Sally Doe 11111 Works part-time
John Doe 2222 Goes to school
John Doe 2222 Works part-time

Since contact ID for the contact (unique identifier) is repeated numerous times, depending on how many times the contact is listed in separate rows, I don't think Vlookup or IndexMatch will work though I'm not quite sure. Could someone advise me on how to move all data about one contact from multiple rows to one row?

Thank you so much!

[ChemistB]

In a dummy column

Please Login or Register  to view this content.

In another sheet, bring over the unique names and IDs in A and B and then in C copied across and down

Please Login or Register  to view this content.

Does that work for you?