取各區非空白成一行 (9759)

L2:T6{=IFERROR(INDIRECT(TEXT(SMALL(IF(OFFSET($A$2:$J$6,MAX(ROW(A1)*5-5),)<>"",(ROW($2:$6)+ROW(A1)*5-5)/1%+$A$1:$J$1),COLUMN(A1)),"!R0C00"),),"")