Converting an ordered list to broadsheet format
I have an ordered list which is name, subject, etc.
Each name has multiple row entries so
and I wan't this in a broadsheet format like:
Is there an easy way to do this in excel? I kind of got the right format using a pivot table but I couldn't get the original grade values to show, only the totals because of the pivot table doing it's normal calculations. Any ideas? I am sure this should be straight forward, but I am just having one of those days.