Excel 2007 : Transposing 3 columns into multiple columns

I'm trying to automatically tranpose 3 columns of students grade predictions into mutiple columns with the students name in one column and other subject predictions in other columns reading across the page (rather than down the page)

Please see the attached spreadsheet which illustrates what I'm trying to do. I did this using the transpose option for each student but it would take ages to do this manually.

Thank you for you help.

Regards,

David