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.
Bookmarks