Hi guys

You have all been great helping me create my school's new tracking sheets and the teachers love them.

Currently I have a a 'progress matrix' which counts the numbers of pupils who came in with one grade (eg 2c) and are now on a certain grade (eg 3.3). This is reported in a matrix with colours showing what is deemed good or not.

This is working well......entry down the side and latest grade along the top with a count in the matrix itself.

The teachers are asking if there is any way this could report the pupils names rather than a count.

I get the sense I should use a Pivot Table (new territory for me). I have tried the wizard based on NAME, KS1 Grade, Current Grade...but whatever order I tick the boxes I cannot recreate the KS1 on side, Current on top and names in the matrix.

Any tips?

Thanks

Lewis