excel两行数据合并成一行,重复数据合并,不同数据合并到同一单元格且保留...答:需要加辅助列(黄色区域)G2=IF(IF(ISERROR(VLOOKUP(A2,$A3:$G9,COLUMN(B1),)),"",VLOOKUP(A2,$A3:$G9,COLUMN(B1),))=$B2,B2,B2&IF(ISERROR(VLOOKUP(A2,$A3:$G9,7,)),"",","&VLOOKUP(A2,$A3:$G9,7,)))向下向右复制 M2=INDEX(A:A,MIN(IF(COUNTIF(M$1:M1,$A$2:$A...