1、创建空白excel,插入样例数据:
名称1 数量1 收入1 名称2 数量2 收入2
白萝卜(ZC) 57.9 217.7 西红柿(ZC/) 64.019 665.8
大白菜(ZC) 156.75 313.5 红薯 116.176 464.6
红薯 116.176 464.6 大白菜(ZC) 104.519 250.85
西红柿(ZC/) 70.379 633.4 白萝卜(ZC) 71.439 211.45
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9a504fc2d56285358350f5439fef76c6a7ef631b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在D列插入空列,并将A、B、C三列,做筛选;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d01373f082025aaf74f35aa9f4edab64024f1a8a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、将A列升序排序;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572c1748bbbe8513632762d0c32d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、同样将E、F、G三列做筛选,E列做升序;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600004d28d5e650352ac75cb7d4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、删除D列,则两列数据相同的名称,排列在同一行了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4afbfbedab64034fac3fe564a0c379310b551de5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)