Sort duplicates to one row for mail merge

[taichi56]

I have a worksheet that has about 3000 rows of student information that I need to be able to mail merge. Some students will listed 5 times for each test they have to take. Some students may be listed only once, maybe twice so forth up to a maximum of five. I need to be able to take the students information and put it all on one row.

I have attached a sample sheet. You will see that the first student is John Doe. He is listed 5 times because he has to take 5 tests. How do I get all this information all on one row so I can mail merge each student? Thank you.

[xladept]

Hi taichi56,

Try this - (you'll want to add the headers):

Please Login or Register  to view this content.

[taichi56]

Thank you very much. That worked great. You saved me many, many hours of work.

[xladept]

You're welcome!