excel 多行合并成一行 ,并将不同内容合并成新列内容答:D2=IF(COUNTIF(C$2:C2,C2)=1,MAX(D$1:D1)+1,"")向下复制 E2=A2&IFERROR(","&VLOOKUP(C2,IF({1,0},C3:C16,E3:E16),2,0),"")向下复制 =IFERROR(VLOOKUP(ROW(A1),IF({1,0},$D$2:$D$20,B$2:B$20),2,0),"")向下向右复制 G2=IFERROR(VLOOKUP(I2,$C$2:$E$20...