合併格 彙整一格 (12822)

C3:C12=IF(A4="",A3,IF(B3="","/"&MID(A3,6,9),A3)&IF(B4="",C4,""))

E3:F10{=OFFSET($C$2,SMALL(IF($B$3:$B$12<>"",ROW($1:$10),99),ROW(A1)),-(A$2=$B$2))&""