Single instance of column item in Pivot table

[Audrey]

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:

		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

[Pecoflyer]

Hi
please post a sample sheet. Without that it's difficult to work on PT

[Audrey]

Here's the example. My main problem is to have multiple instances of the "same period of time" in the columns, and I can't group them properly. Thanks!

[p45cal]

You need to change the way your source data is arranged (Power Pivot might do this for you). See attached.