I have data that I want to summarize by sum of the quarters per year into department & year.
I've also done the intended solution below the table data, need a formula to produce the same. I'm not really conversant with transpose/offset formulas and what I've tried so far is far from fruitful!
Any help is welcome

Year Quarter PL DP A&H
2010 1 23 5 19
2010 2 34 9 15
2011 1 65 11 23
2011 2 21 21 13

Required solution should be as below

PL 2010 57
PL 2011 86
DP 2010 14
DP 2011 32
A&H 2010 34
A&H 2011 36