Return multiple values across multiple sheets

This is an ETL(Extract-Transform-Load) task.

I would like running sql to automate it.

 https://b23.tv/3n30jrt

 //select  rowid old_rowid,colIndex[1:19] from consolidateSheet;
create temp table aa as 
select rowid old_rowid,colIndex[1:19] from consolidateSheet where f04!='Students';
 cli_one_dim_with_zero~temp.aa~4;
create temp table cc as 
with bb as (
select *,(cast(regexp2('\d+',属性) as int)-1)/2 grp from aaunion order by old_rowid)
select *,regreplace('(\d+)\/(\d+)\/(\d+)','20$3-$1-$2',group_concat(数量,'</td><td>')) Date_Result from bb group by old_rowid,grp;
cli_no_header;
select f03,f04,f02,Date_Result from cc;

 You can find other ways to acheive it too.