EXCEL 合并 表格 问题,将几行相同的条件合并为一行,数据也要补充好答:假设要合并的表在sheet2、a1:g2,合并后的在sheet1。在在sheet1、b1:g1列公式可能行。b1=if(VLOOKUP(Sheet2!A1:g2,A1:A2,2,FALSE)="","",VLOOKUP(Sheet2!A1:g2,A1:A2,2,FALSE)c1=if(VLOOKUP(Sheet2!A1:g2,A1:A2,3,FALSE)="","",VLOOKUP(Sheet2!A1:g2,A1:A2,3,FALSE).....