Hi,
I have a dataset containing ages ranging from 6 to 17 years in each column (as shown in the example below). I am attempting to categorize these age groups into the following new groups and visualize them in a column chart, displaying the sum of each age group by Sport Club Name:
- Age 6-8
- Age 9-10
- Age 11-13
- Age 14-17
Could someone please provide some assistance?
| Sport Club Name | Age 6 | Age 7 | Age 8 | Age 9 | Age 10 | Age 11 | Age 12 | Age 13 | Age 14 |
| A | 1 | 1 | 6 | 23 | 34 | 11 | 16 | 34 | 12 |
| B | 2 | 3 | 6 | 12 | 32 | 15 | 12 | 34 | 56 |
| C | 1 | 4 | 7 | 1 | 21 | 30 | 17 | 56 | 23 |
| D | 5 | 5 | 8 | 33 | 12 | 12 | 56 | 12 | 12 |
Thanks
