Looking for a Macro or formula to Identify duplicates in Column A and then move data

I'm in the processing of creating a form letter home to students who failed courses this semester. After exporting data I can sort to get the needed info into 2 columns. I want to take the data from sheet 1 and send it to sheet 2 in the format

Sheet 1:
Col A Col B
Student1 Math
Student2 Math
Student2 English
Student3 Science
Student4 Math
Student4 English
Student4 Social Studies
Student5 Science
Student6 Math
Student6 Social Studies
Student6 Science
Student6 English


I want to eliminate the duplicate students and move data from the duplicate student to the next available column in the row of the original student

Sheet2:
ColA ColB Col C Col D Col E Col F
Student1 Math
Student2 Math English
Student3 Science
Student4 Math English Social Studies
Student5 Science
Student6 Math Social Studies Science English


The max courses that could be listed for a student is 7. I've tried using formulas, but after getting it to work for column C, I am stuck.
I've been exploring this site for the past week and I'm very impressed with the assistance received.
Thanks,

Hi

here goes

Please Login or Register  to view this content.

rylo

Damn that was fast. Rylo for pres!
Thanks man!!