Help With Matrix Report.

Hi All,

I have the following matrix report.







Health
1
2
3
4

Std: 1
Health Promotion and Disease Prevention
4
2
4
3

Std: 2
Accessing Health Information, Products, and Services
2
2



Std: 3
Self-Management
2




Std: 4
Influence of Culture, Media, and Technology
2

2


Std: 5
Interpersonal Communication


3


Std: 6
Goal Setting and Decision Making Skills
4


2

Std: 7
Advocating for Health

3





I need a bit of help to do two things.

One is the first row needs to be the average of the matrix columns (1,2,3,4).

Two is for a header row that will span the matrix columns.



So the final output would be;






Average Proficiency Level

Health
1
2
3
4



Overall
2.8
2.3
3
2.5

Std: 1
Health Promotion and Disease Prevention
4
2
4
3

Std: 2
Accessing Health Information, Products, and Services
2
2



Std: 3
Self-Management
2




Std: 4
Influence of Culture, Media, and Technology
2

2


Std: 5
Interpersonal Communication


3


Std: 6
Goal Setting and Decision Making Skills
4


2

Std: 7
Advocating for Health

3







The number of columns can vary from 1 to 4.



Any help would be very much appreciated.