合併一格 所需物料 (9047)

(2007版) E2右拉 下拉{=IFERROR(IF($A$1=A$1,"","、")&INDEX($C:$C,SMALL(IF(ISNUMBER(FIND("、"&$C$2:$C$12&"、","、"&$B2&"、")),ROW($2:$12)),COLUMN(A1)))&F2,"")