here is another way to do it:
I wanted to build a more dynamic workflow than one of the previous comments, but avoid using macros. The workflow will build running averages for all columns in the file.
1) Columns to rows (Transpose)
2) Sorting them correctly (Sort)
3) Building the Avaerage (Multi-Row Formula)
4) Building a Counter per Category (Multi-Row Formula)
5) Replacing the first 9 rows with nulls (Formula)
6) Removing the counter (Select)
7,8,9 Shifting normal columns and average back (+ Formula for correct naming for the averages) (2x Cross Tab, 1x Formula)
10) Join all together
I have tested it using your file and an extended file with 7 different columns and building the average for all of them. There is no need for changing something in the workflow. You could run this with 100+ columns and will get a running average for all of them.
Your file output:
Second test file output:
I'll attach the workflow as well as the sample files (I removed all hard coded average columns in your file).
Let me know what you think.