指定列為5 提前列數字 (14223)

V1:Z5{=INDEX(OFFSET($B$1:$B$37,,(ROW(A1)-1)*4),SMALL(IF(OFFSET($C$1:$C$37,,MAX((ROW(A1)-1)*4))=5,ROW($1:$37),37),COLUMN(A1)))&""

另解{=INDIRECT(TEXT(SMALL(IF(OFFSET($C$1:$C$37,,MAX((ROW(A1)-1)*4))=5,ROW($1:$36)/1%+ROW(A1)*4-2,9999),COLUMN(A1)),"!R0C00"),)&""