Help to consolidate Data into one sheet.

A_SIRAT 

See attached file (added a couple of dummy values in Order sheet 1). Looks good to me but double-check please

A_SIRAT 

create temp table aa as 
select udf_fillna_m(iif(f07 like 'Week:',f08,''),'x') Week,udf_fillna_m(iif(f07 like 'Order nr:',f08,''),'y') Order_nr,udf_fillna_m( iif(f07 like 'Customer:',f08,''),'z') customer, iif((f03 like '-') or (f03 is null),'',f03) f03,iif((f03 like '-') or (f03 is null),'',f04) f04,iif((f05 like '-') or (f05 is null),'',f05) f05,iif((f05 like '-') or (f05 is null),'',f06) f06,iif((f07 like '-') or (f07 is null) or ( regexp('Week|Order nr|Customer',f07)),'',f07) f07,iif((f07 like '-') or (f07 is null) or (regexp('Week|Order nr|Customer',f07)),'',f08) f08 from consolidateSheet;
create temp table bb as 
select Order_nr,Week,customer,f04 Variety_Name,f03 Quantity  from aa where f03!='' union all 
select Order_nr,Week,customer,f06,f05 from aa where f05!='' union all 
select Order_nr,Week,customer,f08 ,f07  from aa where f07!='';
create temp table cc as 
select rowid old_rowid,*,replace(Quantity,',','')/200 `200`,(replace(Quantity,',','')%200)/100 `100` from bb;
//select * from cc;
cli_one_dim~temp.cc~6;
select colIndex[1:5],数量 `Labels To Print
`,属性 `Qty on Label` from ccunion order by old_rowid;