We have some results data that has been given to us in an excel spreadsheet
but is not set out as we would like. Not sure how to go about getting how we
want it, but I'm sure it must be possible.

Data currently has results for each student. The students unique number is
listed in column A and the subject studied in B with grades in C, D and E.
Each student is listed for each subject they study in rows with grades in the
columns for each subject. What we would like is to have the student
appearing in the row once and have a column for each subject's grades (ie 3
columns per subject).

Data as it is now
Column A Column B Column C Column D Column E
Student 1 Business A B B
Student 1 English A A B

What we would like
Column A Bus Grd 1 Bus Grd 2 Bus Grade 3 Eng Grade 1 Eng Grd 2 Eng
Grd 3
Student1 A B B A
A B

Any suggestions as to where we start?