OK so I have this planification sheet on classes and I need to figure out how busy the teachers will be. Here's the data I have:
And the data I'd like to get: (the numbers in the cells are the total of credits in this trimester)
I'm currently using a Pivot Table, but the columns are listed twice (I have put the 'class will be given on', 'class will be given again on', etc. as columns).
I can't seem to regroup them correctly, using the Grouping option. Any hints on how I could achieve this?
Thanks
nb credits | class will be given on | class will be given again on | class will be given again on | ||
class1 | teacherA | 2 | 1st trimester 2017 | 1st trimester 2018 | 1st trimester 2019 |
class2 | teacherB | 3 | 2nd trimester 2017 | 1st trimester 2018 | 2nd trimester 2019 |
class3 | teacher A | 1 | 1st trimester 2018 | 2nd trimester 2018 | 3rd trimester 2019 |
And the data I'd like to get: (the numbers in the cells are the total of credits in this trimester)
1st trimester 2017 | 2nd trimester 2017 | 3rd trimester 2017 | 1st trimester 2018 | etc | |
teacherA | 2 | 0 | 0 | 3 | |
teacherB | 0 | 3 | 0 | 3 |
I'm currently using a Pivot Table, but the columns are listed twice (I have put the 'class will be given on', 'class will be given again on', etc. as columns).
I can't seem to regroup them correctly, using the Grouping option. Any hints on how I could achieve this?
Thanks