11.1 Simple grouping

 

Here below is a data table:

imagepng

We want to group by Class, and calculate the average score of each subject of each class:

=spl("=E(?1).groups(Class;avg(Maths):Maths,avg(English):English,avg(PE):PE)",A1:E12)

imagepng