1、打开电脑中的excel,插入数据透视表,拖动选好列、行、值等字段,生成的表格默认样式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e4dde71190ef76c6adfbbd6e9316fdfaaf51674d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击第一列单元格内的+号展开表格(也可以通过 数据透视表工具 )分析 ,然后展开字段选项;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9198618367adab4c4175c0685d4b31c8601e4b4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、依次点击 数据透视表工具、设计、分类汇总 、不显示分类汇总,可以去除表格中的分类汇总行;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cb8065380cd791237edfd231a3345982b2b780bc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、依次点击 数据透视表工具、设计、总计、对行和列禁用,可以去除表格最后的总计行;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbf4485f37f17d8bc3eb13541bd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、依次点击数据透视表工具、设计、报表布局、以表格形式显示,将表格调整为表格样式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4e4a20a4462309f72b57eb577c0e0cf3d7cad6bf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、调整好的表格,在第一列同一项下均为空,要填充好分类,依次点击 数据透视表工具、设计、报表布局、重复所有项目标签即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/562c11dfa9ec8a13ca3d11a5f903918fa0ecc054?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)