Hi Dave

I think this is what you mean and it works for 2007 so probably does for 2010.
In C1 and D1 put Q1, Q2
In A2, 4, 6,... put your 5 main categories P, C F ... down to A10
In B2, 3, 4, 5, ... put A, B, A, B, ... down to B11
In cols C and D put your data down to row 11.
Highlight A1 to D11. Everything.
Insert - Column - 2D - Stacked.

xt