Reconfigure Data to make it usuable

OK. A bit of tidying up, getting all the range definitions to the start, giving them (slightly) more memorable names, etc, etc. Check it carefully!!!

Formula:

=LET(ID,Sheet1!A2:D200,w,COUNTA(Sheet1!E1:K1),hd,Sheet1!E2:K200,col,COUNTA(Sheet1!A1:D1),rID,ROWS(ID),

ID_F,FILTER(INDEX(ID,1+INT((SEQUENCE(rID*w)-1)/w),SEQUENCE(,col)),{1,0,1,1}),

Day,FILTER(INDEX(ID,1+INT((SEQUENCE(rID*w)-1)/w),SEQUENCE(,col))-(w-(1+MOD(SEQUENCE(w*rID)-1,w))),{0,1,0,0}),

Hrs,INDEX(hd,1+INT((SEQUENCE(rID*w)-1)/w),1+MOD((SEQUENCE(rID*w)-1),w)),

CHOOSE({1,1,1,2,3},ID_F,Day,Hrs))