数据透视表-多列中的键 [英] Pivot Table - Keys from multiple columns

问题描述

我一直在尝试构建一个使用多列键的数据透视表.

I've been trying to build a pivot table that uses keys from multiple columns.

这将是源表(项目1,2,3列代表键):

This would be the source table (Items 1,2,3 columns represent the keys):

[

这将是生成的数据透视表(数据透视表合并了键"A"，即使它位于其他列中也是如此):

This would be the resulting Pivot Table (The pivot table consolidates key "A" even though it is placed in other columns) :

] 抱歉，这是一个非常容易解决的问题.

Sorry if this is a terribly easy one to solve.

谢谢.

推荐答案

您需要使用合并范围数据透视表. Alt + DP，然后选择合并范围作为源并分别添加每对列.您将需要所有成对的列都具有相同的标题.

You need to use a consolidation range pivot table. Alt+DP, then choose consolidation ranges as the source and add each pair of columns separately. You'll need the pairs of columns to all have the same headers.

还要注意，合并范围的枢轴在您可以使用它们的方式方面非常有限.

Note also that consolidation range pivots are quite limited in terms of what you can do with them.

这篇关于数据透视表-多列中的键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！