轉置 二維成一維 (12924)

I2{=IFERROR(INDIRECT(TEXT(SMALL(IF(A$1:F$5<>"",ROW($1:$5)/1%+COLUMN(A:F)),ROW(A1)),"!R0C00"),),"")



留言