轉換 指定列数 跳過空格 (8975)


L2:U2 下拉 {=IFERROR(IF(COLUMN(A1)>$W$2,"",INDIRECT(TEXT(SMALL(IF($A$2:$J$12<>"",ROW($2:$12)/1%+COLUMN($A:$J)),ROW(A1)*$W$2-$W$2+COLUMN(A1)),"!R0C00"),)),"")


留言