You have to develop something like this or send your file to adapt it :
temp: CrossTable(Month, Data) LOAD * FROM $(Path)\$(File).xlsx (ooxml, embedded labels, table is Feuil1);
temp2: Load Prod, if(isnum(mid(Month,2))=False() and len(trim(Month))>1,Month,peek(Month)) as Month, Data, recno() as recno Resident temp ;
DROP TABLE temp;
temp3: Load Prod, Month, tmpType1, if(len(trim(tmpType1))=0,peek(tmpType1)) as Type1, Type2; Load Prod, Month, if(mod(recno,3)=2,Data) as tmpType1, if(mod(recno,3)=0,Data) as Type2 Resident temp2 Where mod(recno,3)<>1 and len(trim(Prod))>0;
And also can you please tell me how to create dates column for this table...i.e.
I should divide the Hours, Revenue by number of days in month Ex: for Jan the data should be divided by 31 (# of days in jan), 28 for Feb ...and sum by weekly... if the jan month ends in middle of the week then only calculate for jan and remaining for feb