I am trying to summarise student data in a way that it displays exam score
and grade next to each other, eg
Maths History
1234 Jhon Citizen 75% 7 65% 6

So far I manage to get Pivot table to show grade underneath the score, eg

1234 John Citizen 75% 65%
7 6

Is there a way to this with pivot tables?
Thanks