Dynamic table? maybe?

[ExcelQA]

Hi everyone, I have little bit of a challenge. I developed a model for a colleague who is very used to "his format". Is there a way to create a dynamic (non pivot table) to automatically transform the data into one with the format below? the challenge is that for example on the table below the level 0 and level 2 changes month over month

 

[ExcelQA]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Level 2	Level 1	Level 0	Total
2	Mig29	ABC	RU	1000	397	889			RU
3	SU35	ABC	RU	1700	617	224				Mig29	1000	397	889
4	Tornado	DCB	UK	2000	909	784				SU35	1700	617	224
5	Typhoon	DCB	UK	2500	892	852					2700	1014	1113
6	Viggen	XCY	SWE	1000	367	497			UK
7	Grippen	XCY	SWE	1700	598	866				Tornado	2000	909	784
8	Baloon	DEF	US	100	314	317				Typhoon	2500	892	852
9	F22	DEF	US	3000	937	501					4500	1801	1636
10	V22	DEF	US	800	442	502			SWE
11	F16	DEF	US	1000	390	885				Viggen	1000	367	497
12										Grippen	1700	598	866
13											2700	965	1363
14									US
15										Baloon	100	314	317
16										F22	3000	937	501
17										V22	800	442	502
18										F16	1000	390	885
19											4900	2083	2205
Sheet3

Cell Formulas
Range	Formula
I2:M19	I2	=LET(u,UNIQUE(FILTER(C2:C100,C2:C100<>"")),DROP(REDUCE("",u,LAMBDA(x,y,VSTACK(x,VSTACK(EXPAND(y,,5,""),IFNA(HSTACK("",FILTER(CHOOSECOLS(A2:F100,1,4,5,6),C2:C100=y)),"")),CHOOSE({1,2,3,4,5},"","",SUMIFS(D:D,C:C,y),SUMIFS(E:E,C:C,y),SUMIFS(F:F,C:C,y))))),1))
Dynamic array formulas.

FLUFF, Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.