optional way with Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
TCT = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Group", Int64.Type}, {"Result 1", Int64.Type}, {"Result 2", Int64.Type}, {"Result 3", Int64.Type}, {"Result 4", Int64.Type}}),
GRP = Table.Group(TCT, {"Group"}, {{"Avg1", each List.Average([Result 1]), type number}, {"Avg2", each List.Average([Result 2]), type number}, {"Avg3", each List.Average([Result 3]), type number}, {"Avg4", each List.Average([Result 4]), type number}})
in
GRP
Group |
Avg1 |
Avg2 |
Avg3 |
Avg4 |
1 |
55.38596491 |
55.84210526 |
49.47368421 |
69.01754386 |
2 |
46.55932203 |
42.18644068 |
51.42372881 |
55.88135593 |
3 |
52.45614035 |
57.89473684 |
67.57894737 |
51.15789474 |
4 |
56.78947368 |
61.92982456 |
69.75438596 |
59.96491228 |
5 |
54.75 |
52.03846154 |
59.5 |
65.03846154 |
Bookmarks