Help pivot table? Merge? Mail Merge?

Hello Everyone,

I'm new and I need your help! I have an excel file with a list of students and classes they are taking; however, each class lists the student up to however many number they are taking. There are hundreds of students so I don't want to do it manually.

Example of the problem

Name ID CLASS
John Smith 1234567889 College Algebra
John Smith 1234567889 College English
John Smith 1234567889 College Business

what I need

Name ID CLASS 1 CLASS 2 CLASS 3
John Smith 1234567889 College Algebra College English College Business


In order for me to create a mail merge for word document to create a summary of what a student has taken, I will need all the classes in the same row and create new columns. I assume that it can be done, but i've wasted my time on youtube trying to figure it out and it has not been fruitful.

If you can help, i would be eternally grateful.