彙整一列 星期之間空一格 (13708)

I2:J8{=INDEX($B:$B,SMALL(IF($C$2:$F$4=$H2,{2;3;4},99),COLUMN(A1)))&""

L2:L26{=IFERROR(IF(OR(ROW(A1)=COUNTIFS(OFFSET(H$2:J$2,,,ROW($1:$7)),"><")+ROW($1:$7)),"",INDIRECT(TEXT(SMALL(IF(H$2:J$8<>"",ROW($2:$8)/1%+{8,9,10}),ROW(A1)-COUNTIF(L$1:L1,"")),"!R0C00"),)),"")