Arranging XL dynamic Data (fetched through query)

[M Rizwan Khan]

I have a sheet with dynamic (changeable) data like

Incharge Name, Sector Name, Variety Name, Vehicle Count, weight
A s1 v1 5 500
A s2 v2 3 250
A s1 v3 9 1100
B s4 v1 4 350
C s5 v5 3 400
C s6 v3 5 600

I would like to arrange this tabular data in the below format
V1 V2 S/Total V3 V5 S/Total Total (sum of both sub-totals)
Incharge, Sector, Count Weight, Count Weight, Count Weight, Count Weight, Count Weight, Count Weight, Count Weight
A S1 5 500 5 500 9 1100 9 1100 14 1600
A S2 3 250 3 250 3 250
B S4 4 350 4 350 4 350
C
C

Pls help
Thanks

Variety-wise Sugarcane Supply Position.xlsx
	C	D	E	F	G	H	I
3	NameOfIncharge	Sector Code	Sector Name	VarietyTypeCode	VarietyType	Loads	sMunds
4	ABDUL HAKEEM (Sr. CANE MANAGER)	04-02	DARO SANDI	01	Programmed Varieties	209	41081.1
5	ABDUL HAKEEM (Sr. CANE MANAGER)	04-02	DARO SANDI	02	Improved (Early) Varieties	2	936.1
6	ABDUL HAKEEM (Sr. CANE MANAGER)	04-02	DARO SANDI	05	Inferior Varieties	10	3649.3
7	ABDUL HAKEEM (Sr. CANE MANAGER)	04-03	PHALKARA	01	Programmed Varieties	5	644.925
8	ABDUL HAKEEM (Sr. CANE MANAGER)	04-03	PHALKARA	02	Improved (Early) Varieties	14	6823.325
9	ABDUL HAKEEM (Sr. CANE MANAGER)	08-01	MATLI	01	Programmed Varieties	41	11042.875
10	ABDUL HAKEEM (Sr. CANE MANAGER)	08-01	MATLI	02	Improved (Early) Varieties	118	37909.75
11	ABDUL HAKEEM (Sr. CANE MANAGER)	08-01	MATLI	03	Improved (Mid Late) Varieties	1	322.475
12	ABDUL HAKEEM (Sr. CANE MANAGER)	08-01	MATLI	05	Inferior Varieties	1	558.25
13	ABDUL HAKEEM (Sr. CANE MANAGER)	08-01	MATLI	06	Pipe Line Varieties	8	3680.6
14	ABDUL HAKEEM (Sr. CANE MANAGER)	08-04	KALRO MORI	02	Improved (Early) Varieties	1	568.175
30	AGHA MASHOOQUE ALI (DGM-CD)	02-01	DIGH MORI	01	Programmed Varieties	102	32480.7
31	AGHA MASHOOQUE ALI (DGM-CD)	02-01	DIGH MORI	02	Improved (Early) Varieties	13	9599.85
32	AGHA MASHOOQUE ALI (DGM-CD)	02-01	DIGH MORI	04	Other Varieties	1	663.075
33	AGHA MASHOOQUE ALI (DGM-CD)	02-01	DIGH MORI	05	Inferior Varieties	23	11143.275
34	AGHA MASHOOQUE ALI (DGM-CD)	02-01	DIGH MORI	06	Pipe Line Varieties	3	1562.175
35	AGHA MASHOOQUE ALI (DGM-CD)	05-04	SERI	01	Programmed Varieties	4	1631.475
36	AGHA MASHOOQUE ALI (DGM-CD)	05-05	VIDH	01	Programmed Varieties	18	6148.575
37	AGHA MASHOOQUE ALI (DGM-CD)	05-05	VIDH	02	Improved (Early) Varieties	18	6534.15
38	AGHA MASHOOQUE ALI (DGM-CD)	07-01	TANDO MUHAMMAD KHAN	01	Programmed Varieties	67	17209.625
39	AGHA MASHOOQUE ALI (DGM-CD)	07-01	TANDO MUHAMMAD KHAN	02	Improved (Early) Varieties	10	3738.75
47	MUHAMMAD ASHIQUE (DGM-CANE)	01-02	JHAN MORI	01	Programmed Varieties	413	202799.575
48	MUHAMMAD ASHIQUE (DGM-CANE)	01-02	JHAN MORI	02	Improved (Early) Varieties	39	14855.55
49	MUHAMMAD ASHIQUE (DGM-CANE)	01-02	JHAN MORI	05	Inferior Varieties	7	3853.95
50	MUHAMMAD ASHIQUE (DGM-CANE)	01-02	JHAN MORI	06	Pipe Line Varieties	2	740.6
51	MUHAMMAD ASHIQUE (DGM-CANE)	01-03	GATE (1)	01	Programmed Varieties	321	78962.65
Sheet1