Data Transformation using VBA like subtotal

MyQueries 

Can't access the file you shared 😞 Could you try again please?

MyQueries 

sql:

select * from GenerateSubtotal limit 20;

create temp table aa as
select 'a'||f03||'t' ord,'' f01,'Total' f02,f03,
colIdxf[3:6]{'' %s}, sum(cast(replace(f08,',','') as double)) f08,
f09,f10,f11,f12,f13,f14,f15,f16 from GenerateSubtotal group by f03 order by ord;
create temp table bb as
select f03,group_concat(ATI,'<br>') f09 from (select f03,f06,count(f06)||' site '||cast(f06*100 as text)||'% ATI '||f09 ATI from GenerateSubtotal group by f03,f06,f09) group by f03;

// change group from f03,f06 to f03,f06,f09
//select * from bb;
create temp table cc as
select ord,f01,f02,'' f03,f04,f05,f06,f07,f08,bb.f09,f10,f11,f12,f13,f14,f15,f16 from aa join bb using(f03);
//select * from cc;
create temp table dd as
select 'a'||f03 ord,* from GenerateSubtotal union all select * from cc order by ord;
select colIndex[1:] from dd;