How to collapse Data into one line (similar to a transpose, but not quite)

[dyoung66]

Hello,

I was hoping someone might be able to provide some insight in to a problem Im stuck on.

I have the following data format in excel:

studentID lName fName HomeGrp classCode className teacherCode teacherLname teacherfName (all on one line)

this data is repeated for each class the student is in per line, so the same studentID can appear each line for each different class they are in.

I am trying to "collapse" the last 5 fields to append onto the end of the first line, so that I only have one line for each student, with multiple classes and teachers appearing at the end of the appropriate line.

Example:
studentID lName fName HomeGrp classCode className teacherCode teacherLname teacherfName classCode1 className1 teacherCode1 teacherLname1 teacherfName1 etc....

I have been blundering about with Excel Macros, but Im not skilled with them. I was hoping someone might be able to point me in the right direction.

Thanks for your time,
Damien.

[shg]

Why? The data is much more suitable for analysis in its current state.

[dyoung66]

I need each individual student record on one line so I can do a mail merge.

[dyoung66]

Thanks shg, youve made me rethink my attack.

My problem can be overcome by using the "IF" statement within my mail merge.

Here is the link that explains it all much better than I ever could:

WD2000: How to Work Around Duplicate Names in Mail Merge Data

http://support.microsoft.com/kb/302665

[shg]

Well done!