刪除空白 (12329)

C2:C9{=INDEX(B:B,SMALL(IF(B$2:B$9<>"",ROW($2:$9),99),ROW(A1)))&""

I2:K9{=INDEX(E:E,SMALL(IF(MMULT(N($E$2:$G$9<>""),{1;1;1})=3,ROW($2:$9),99),ROW(A1)))&""



留言