彙整一列 多列非空 (12344)

A2{=INDIRECT(TEXT(SMALL(IF(B$2:F$7<>"",ROW($2:$7)/1%+COLUMN(B:F),9999),ROW(A1)),"!R0C00"),)&""



留言