Pivot table with different operations for columns

Suppose I have a table that rows represent yyyymmdd and columns represent height and weights.

I want to create a pivot table that rows represent yyyymm and columns represent average of heights and sum of weights (say).

Please advise how to proceed.

Answer 1

[Peter Perkins]

Look at using a timetable, and look at using varfun with year/month as your grouping variable(s).

[alpedhuez]

or using grpstats.