...
11.1 Simple grouping
Here below is a data table:
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)
esProc Desktop and Excel Processing
10.14 Rank in group
11.2 Group by combination of multiple columns