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
Bookmarks