合併格 数据匹配 (9003)

G3:H9=IF((G2="")+((ROW(A1)>1)*(OFFSET($B$1,MATCH($F$3,$B:$B,)+ROW(A1)-2,)<>"")),"",OFFSET(C$1,MATCH($F$3,$B:$B,)+ROW(A1)-2,)&"")

另解 G12:H17{=INDEX(C:C,SMALL(IF(LOOKUP(ROW($3:$17),ROW($3:$17)/($B$3:$B$17<>""),$B$3:$B$17)=$F$3,ROW($3:$17),99),ROW(A1)))&""