Should have added the result when it's in a Pivot Table. Is this what you are after?
Average of Value | | | | | | | | | | | | |
| | | | | | | | | | | | |
Row Labels | Green | Amber | Red | Green | Amber | Red | Green | Amber | Red | Green | Amber | Red |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
<tbody>
[TD="width: 141, colspan: 3"]Column Labels[/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="width: 47"][/TD]
[TD="colspan: 2"]Result 1[/TD]
[TD="colspan: 2"]Result 2[/TD]
[TD="colspan: 2"]Result 3[/TD]
[TD="colspan: 2"]Result 4[/TD]
[TD="class: xl65"]Canada[/TD]
[TD="class: xl66, align: right"]90.3[/TD]
[TD="class: xl66, align: right"]64.0[/TD]
[TD="class: xl66, align: right"]28.5[/TD]
[TD="class: xl66, align: right"]86.5[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]26.5[/TD]
[TD="class: xl66, align: right"]94.0[/TD]
[TD="class: xl66, align: right"]36.0[/TD]
[TD="class: xl66, align: right"]13.5[/TD]
[TD="class: xl66, align: right"]71.3[/TD]
[TD="class: xl66, align: right"]33.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]China[/TD]
[TD="class: xl66, align: right"]89.8[/TD]
[TD="class: xl66, align: right"]65.1[/TD]
[TD="class: xl66, align: right"]25.4[/TD]
[TD="class: xl66, align: right"]87.1[/TD]
[TD="class: xl66, align: right"]55.4[/TD]
[TD="class: xl66, align: right"]20.4[/TD]
[TD="class: xl66, align: right"]81.0[/TD]
[TD="class: xl66, align: right"]43.3[/TD]
[TD="class: xl66, align: right"]14.9[/TD]
[TD="class: xl66, align: right"]75.8[/TD]
[TD="class: xl66, align: right"]34.6[/TD]
[TD="class: xl66, align: right"]11.6[/TD]
[TD="class: xl65"]Croatia[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]58.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]62.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]66.0[/TD]
[TD="class: xl66, align: right"]45.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]95.0[/TD]
[TD="class: xl66, align: right"]22.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]France[/TD]
[TD="class: xl66, align: right"]86.2[/TD]
[TD="class: xl66, align: right"]61.1[/TD]
[TD="class: xl66, align: right"]28.1[/TD]
[TD="class: xl66, align: right"]85.6[/TD]
[TD="class: xl66, align: right"]57.4[/TD]
[TD="class: xl66, align: right"]23.4[/TD]
[TD="class: xl66, align: right"]75.8[/TD]
[TD="class: xl66, align: right"]46.7[/TD]
[TD="class: xl66, align: right"]10.8[/TD]
[TD="class: xl66, align: right"]80.2[/TD]
[TD="class: xl66, align: right"]36.9[/TD]
[TD="class: xl66, align: right"]5.8[/TD]
[TD="class: xl65"]Germany[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]24.7[/TD]
[TD="class: xl66, align: right"]96.0[/TD]
[TD="class: xl66, align: right"]63.0[/TD]
[TD="class: xl66, align: right"]5.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]45.5[/TD]
[TD="class: xl66, align: right"]16.0[/TD]
[TD="class: xl66, align: right"]82.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]10.5[/TD]
[TD="class: xl65"]Japan[/TD]
[TD="class: xl66, align: right"]87.3[/TD]
[TD="class: xl66, align: right"]60.6[/TD]
[TD="class: xl66, align: right"]37.8[/TD]
[TD="class: xl66, align: right"]82.8[/TD]
[TD="class: xl66, align: right"]58.5[/TD]
[TD="class: xl66, align: right"]17.8[/TD]
[TD="class: xl66, align: right"]79.0[/TD]
[TD="class: xl66, align: right"]35.7[/TD]
[TD="class: xl66, align: right"]9.3[/TD]
[TD="class: xl66, align: right"]74.8[/TD]
[TD="class: xl66, align: right"]29.0[/TD]
[TD="class: xl66, align: right"]9.4[/TD]
[TD="class: xl65"]Russia[/TD]
[TD="class: xl66, align: right"]91.0[/TD]
[TD="class: xl66, align: right"]63.4[/TD]
[TD="class: xl66, align: right"]27.8[/TD]
[TD="class: xl66, align: right"]85.6[/TD]
[TD="class: xl66, align: right"]52.8[/TD]
[TD="class: xl66, align: right"]21.1[/TD]
[TD="class: xl66, align: right"]80.2[/TD]
[TD="class: xl66, align: right"]45.7[/TD]
[TD="class: xl66, align: right"]14.6[/TD]
[TD="class: xl66, align: right"]74.7[/TD]
[TD="class: xl66, align: right"]35.1[/TD]
[TD="class: xl66, align: right"]14.0[/TD]
[TD="class: xl65"]United Kingdom[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]19.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]42.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]58.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]59.0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]71.8[/TD]
[TD="class: xl66, align: right"]26.3[/TD]
[TD="class: xl66, align: right"]86.3[/TD]
[TD="class: xl66, align: right"]52.6[/TD]
[TD="class: xl66, align: right"]20.2[/TD]
[TD="class: xl66, align: right"]88.4[/TD]
[TD="class: xl66, align: right"]47.7[/TD]
[TD="class: xl66, align: right"]14.5[/TD]
[TD="class: xl66, align: right"]67.6[/TD]
[TD="class: xl66, align: right"]34.6[/TD]
[TD="class: xl66, align: right"]4.0[/TD]
</tbody>