Merging duplicate column ID's and placing specific column as a row

Hi, i have been struggling with how to get this working. I tried merging/grouping/transposing, but i dont seem to be doing it right.   I have a list of students with grades for different subjects: ...