合併 同上填滿 (10298)


F2:H16=INDEX(LOOKUP(ROW(B$2:B$19),ROW(B$2:B$16)/(B$2:B$19<>""),B$2:B$19),ROW(A1))


另解=IF(B2<>"",B2,F1)


留言