Can you just clarify how you want the data to be presented? Do you want
a table which shows the Groups and a separate table showing the
sub-groups? Something like:

Total
A x
B x
C x

and

Total
A 0 x
A 1 x
A 1a x
A 2 x
B 0 x
B 1 x
B 1a x
B 2 x


If so, how many main groups do you have (and are these really letters),
and what sub-groups do you have? Will it be okay to have these summary
tables in a separate sheet, so that you can paste your data into Sheet1
each time? If you have 25 more duration columns, does this mean your
main data sheet goes out to column AD ?

Pete