彙整 非空數據 (10164)

C3{=IFERROR(TEXT(INDEX(A:A,SMALL(IF(A$3:A$21<>"",ROW($3:$21)),ROW(A1))),"YYY年M月D日;;;"),"")

D3{=IF(C3="",INDEX(A:A,SMALL(IF((A$4:A$21<>"")*ISERR(-A$4:A$21),ROW($4:$21),99),COUNTIF(C3:C$4,"")))&"","")