最后一行数据转成列数据 (11019)

M2:M11 {=INDIRECT(TEXT(SMALL(IF(OFFSET(B$1,LOOKUP(1,0/MMULT(N(B$1:K$9999<>""),ROW(1:10)^0),ROW($1:$9999))-1,,,10)<>"",LOOKUP(1,0/MMULT(N(B$1:K$9999<>""),ROW(1:10)^0),ROW($1:$9999))/1%+COLUMN(B:K)),ROW(A1)),"!R0C00"),)

不會超過層次{=INDIRECT(TEXT(RIGHT(SMALL(IF((ROW($1:$9999)=LOOKUP(1,0/MMULT(N(B$1:K$9999<>""),ROW($1:$10)^0),ROW($1:$9999)))*(B$1:K$9999<>""),ROW($1:$9999)/1%+COLUMN(B:K),10^6-1),ROW(A1)),6),"!R0C00"),)&""