I have an Excel file which look like this:

student 1 Eng A
student 1 Math B
Student 1 Hist B
Student 1 Geog C
Student 2 Eng D
Student 2 Math C
Student 2 chem D

I would like to convert it into the following format:

Eng Math Hist Geog Chem
student 1 A B B C
student 2 D C D

Can any it be done in VBA?