Struggling to organise my data for work

[wrighty998]

[TABLE="class: grid, width: 500"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:7753;width:159pt" width="212"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:2377;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:2304;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="width:48pt" width="64" span="9"> </colgroup><tbody>[TR]
[TD="width: 212"]Area: 02 - Surrey / Hants
[/TD]
[TD="width: 77"]apple[/TD]
[TD="width: 65"]banana[/TD]
[TD="width: 63, align: right"]897596[/TD]
[TD="width: 73"] [/TD]
[TD="width: 64, align: right"]0[/TD]
[TD="width: 64, align: right"]13[/TD]
[TD="width: 64, align: right"]0[/TD]
[TD="width: 64, align: right"]0[/TD]
[TD="width: 64, align: right"]0[/TD]
[TD="width: 64, align: right"]0[/TD]
[TD="width: 64, align: right"]4[/TD]
[TD="width: 64, align: right"]5[/TD]
[TD="width: 64"] [/TD]
[/TR]
[TR]
[TD]Area: 02 - Surrey / Hants
[/TD]
[TD]apple[/TD]
[TD]banana[/TD]
[TD="align: right"]897959[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD]install
[/TD]
[/TR]
[TR]
[TD]Area: 02 - Surrey / Hants
[/TD]
[TD]apple[/TD]
[TD]banana[/TD]
[TD="align: right"]897961[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Area: 02 - Surrey / Hants[/TD]
[TD]pear[/TD]
[TD]apple
[/TD]
[TD="align: right"]896451[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[TD]install[/TD]
[/TR]
[TR]
[TD]Area: 02 - Surrey / Hants
[/TD]
[TD]pear[/TD]
[TD]apple
[/TD]
[TD="align: right"]898202[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0
[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9[/TD]
[TD]install[/TD]
[/TR]
[TR]
[TD]Area: 16 - Ireland[/TD]
[TD]pear[/TD]
[TD]apple[/TD]
[TD="align: right"]895851[/TD]
[TD] [/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]26
[/TD]
[TD]install
[/TD]
[/TR]
</tbody>[/TABLE]

need to consolodate my data, if coloumn a,b,c match then consolodate numbers in row d into one cell, and sum row f,g,h,i,j,k,l,m and count n

thanks

 

[Special-K99]

Row D ? Do you mean column D or row 4, rows usually have numbers columns usually have letters.

What's your expected output look?

 

[wrighty998]

sorry yeah,

if coloumn A,B,C match then consolodate coloumn D into one cell and sum up coloumn F,G,H,I,J,K,L,M and count N

thanks

 

[Special-K99]

What's your expected output look?

As above

 

[wrighty998]

As above

[TABLE="class: cms_table_grid"]
<tbody>[TR]
[TD="width: 212"]Area: 02 - Surrey / Hants
[/TD]
[TD="width: 77"]apple[/TD]
[TD="width: 65"]banana[/TD]
[TD="width: 63, align: right"]897959,897596,897961
[/TD]
[TD="width: 73"][/TD]
[TD="width: 64, align: right"]1
[/TD]
[TD="width: 64, align: right"]13[/TD]
[TD="width: 64, align: right"]3
[/TD]
[TD="width: 64, align: right"]2
[/TD]
[TD="width: 64, align: right"]9
[/TD]
[TD="width: 64, align: right"]0[/TD]
[TD="width: 64, align: right"]8
[/TD]
[TD="width: 64, align: right"]18
[/TD]
[TD="width: 64"]1
[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]Area: 02 - Surrey / Hants
[/TD]
[TD]pear[/TD]
[TD]apple[/TD]
[TD="align: right"]898202,896451
[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]Area: 16 - Ireland
[/TD]
[TD]pear
[/TD]
[TD]apple[/TD]
[TD="align: right"]895851[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]26 [/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

sorry thats the output, there is 700 lines of data so to have it consolodate would be very helpfull

 

[Special-K99]

You may be able to produce this from a pivot table or VBA definitely.
Unfortunately it's beyond my VBA expertise.

 

[wrighty998]

You may be able to produce this from a pivot table or VBA definitely.
Unfortunately it's beyond my VBA expertise.

tried a pivot table but it wont consolade the the numbers together into one cell, it still splits them so its no good