假如这个数据是在Sheet1中，需要汇总到Sheet2中，两个表的名称均在A1单元格，名称为均在B1单元格，数量为均在C1单元格
那sheet2中
A2=IF(ISERROR(LOOKUP(Sheet1!$A2,Sheet1!$A:$C,Sheet1!$A:$A)),"",LOOKUP(Sheet1!$A2,Sheet1!$A:$C,Sheet1!$A:$A))
B2=IF(ISERROR(LOOKUP(Sheet1!$B2,Sheet1!$A:$C,Sheet1!$B:$B)),"",LOOKUP(Sheet1!$B2,Sheet1!$A:$C,Sheet1!$B:$B))
C2=IF(ISERROR(LOOKUP(Sheet1!$C2,Sheet1!$A:$C,Sheet1!$C:$C)),"",LOOKUP(Sheet1!$C2,Sheet1!$A:$C,Sheet1!$C:$C))
然后分别下拉
