二列追尾一列 (10816)

D2=OFFSET(A$1,ROW(A1)-(ROW(A1)>COUNTA(A:A)-1)*(COUNTA(A:A)-1),ROW(A1)>COUNTA(A:A)-1)&""

E2{=INDIRECT(TEXT(RIGHT(SMALL(IF(A$2:B$100<>"",ROW($2:$100)/1%+{1,2}*10001,9^9),ROW(A1)),4),"!r0c00"),)&""