C2=B2&IFERROR("、"&VLOOKUP(A2,A3:C31,3,0),"")
D2=IF(COUNTIF(A$2:A2,A2)=1,MAX(D$1:D1)+1,"")
F2=IF(ROW(A1)>MAX(D:D),"",INDEX($A$2:$A$31,MATCH(ROW(A1),$D$2:$D$31,0)))
G2=VLOOKUP(F2,$A$2:$C$31,3,0)
写代码可以处理
没明白
