Move all to one row

Question

I have a report of 60,000 loan numbers,

borrowers first and last names

tax ID numbers.

Some loans have multiple borrowers and are laid out in consecutive order on the spreadsheet.

Meaning,

Loan #123 Tom Smith tax ID # 5555 is one row

Loan #123 Mary Smith tax ID # 8888 is a second row. There can be 1 to 10 borrowers per loan number.

I need all the borrowers with the same loan number their name and tax ID moved to one row.

All on one row. Loan #123, Tom Smith, Tax ID# 5555, Mary Smith, Tax ID # 8888

Make sense?

Answer 1

Can you provide what the row looks like now and what you want it to look like?

Do you want data in separate columns too?