表格轉換 (10546)

M2 下拉 {=IFERROR(INDIRECT(TEXT(SMALL(IF(ISERR(-A$2:F$5),ROW($2:$5)/1%+COLUMN(A:F)),ROW(A1)),"!R0C00"),),"")

N2 下拉 {=IF(ISNUMBER(FIND("区",M2))+(M2=""),"",INDIRECT(TEXT(SMALL(IF(ISNUMBER(-C$2:G$5)*(C$2:G$5<>""),ROW($2:$5)/1%+COLUMN(C:G)),SUM(N(N$1:N1<>""))),"!R0C00"),))