i have a spreadsheet that shows a sample of pupils listing SEN coding and
category discriptions.

I need to summarise the data to produce a table which shows the % of pupils
in each sen code by school and gender and total on the female / male.