Excel数据透视表
posfan12
我有一个工作表，其数据类似于以下内容：
P1_ShipType P2_ShipType RoundTime
Kus_AssaultFrigate Tai_AssaultFrigate 117
Kus_AssaultFrigate Tai_AttackBomber 17
Kus_AssaultFrigate Tai_Carrier 1191
Kus_AttackBomber Tai_AssaultFrigate 2775
Kus_AttackBomber Tai_AttackBomber 18
Kus_AttackBomber Tai_Carrier 0
Kus_Carrier Tai_AssaultFrigate 1354
Kus_Carrier Tai_AttackBomber 8
Kus_Carrier Tai_Carrier 0
我如何“旋转”表，使其看起来像这样：
Tai_AssaultFrigate Tai_AttackBomber Tai_Carrier
Kus_AssaultFrigate 117 17 1191
Kus_AttackBomber 2775 18 0
Kus_Carrier 1354 8 0
谢谢！
[编辑]
但是，如果每个RoundTime有多个列怎么办？
P1_ShipType P1_Research P2_ShipType P2_Research RoundTime
Kus_AssaultFrigate guns Tai_AssaultFrigate guns 48
Kus_AssaultFrigate guns Tai_AttackBomber guns 11
Kus_AssaultFrigate guns Tai_Carrier guns 38
Kus_AttackBomber guns Tai_AssaultFrigate guns 62
Kus_AttackBomber guns Tai_AttackBomber guns 70
Kus_AttackBomber guns Tai_Carrier guns 69
Kus_Carrier guns Tai_AssaultFrigate guns 5
Kus_Carrier guns Tai_AttackBomber guns 84
Kus_Carrier guns Tai_Carrier guns 77
Kus_AssaultFrigate guns Tai_AssaultFrigate engines 83
Kus_AssaultFrigate guns Tai_AttackBomber engines 82
Kus_AssaultFrigate guns Tai_Carrier engines 29
Kus_AttackBomber guns Tai_AssaultFrigate engines 97
Kus_AttackBomber guns Tai_AttackBomber engines 22
Kus_AttackBomber guns Tai_Carrier engines 10
Kus_Carrier guns Tai_AssaultFrigate engines 71
Kus_Carrier guns Tai_AttackBomber engines 3
Kus_Carrier guns Tai_Carrier engines 38
Kus_AssaultFrigate engines Tai_AssaultFrigate guns 34
Kus_AssaultFrigate engines Tai_AttackBomber guns 21
Kus_AssaultFrigate engines Tai_Carrier guns 84
Kus_AttackBomber engines Tai_AssaultFrigate guns 51
Kus_AttackBomber engines Tai_AttackBomber guns 73
Kus_AttackBomber engines Tai_Carrier guns 27
Kus_Carrier engines Tai_AssaultFrigate guns 66
Kus_Carrier engines Tai_AttackBomber guns 82
Kus_Carrier engines Tai_Carrier guns 22
Kus_AssaultFrigate engines Tai_AssaultFrigate engines 10
Kus_AssaultFrigate engines Tai_AttackBomber engines 63
Kus_AssaultFrigate engines Tai_Carrier engines 2
Kus_AttackBomber engines Tai_AssaultFrigate engines 94
Kus_AttackBomber engines Tai_AttackBomber engines 44
Kus_AttackBomber engines Tai_Carrier engines 93
Kus_Carrier engines Tai_AssaultFrigate engines 5
Kus_Carrier engines Tai_AttackBomber engines 53
Kus_Carrier engines Tai_Carrier engines 80
结果如下所示：
Tai_AssaultFrigate Tai_AttackBomber Tai_Carrier Tai_AssaultFrigate Tai_AttackBomber Tai_Carrier
guns guns guns engines engines engines
Kus_AssaultFrigate guns 117 17 1191 117 17 1191
Kus_AttackBomber guns 2775 18 0 2775 18 0
Kus_Carrier guns 1354 8 0 1354 8 0
Kus_AssaultFrigate engines 117 17 1191 117 17 1191
Kus_AttackBomber engines 2775 18 0 2775 18 0
Kus_Carrier engines 1354 8 0 1354 8 0
单位
您可以选择数据范围，然后在excel中进行选择；
Insert--> Pivot Table.
然后选择如下所示的数据字段。
Row Lables --> P1_ShipType
Column LAble -->P2_ShipType
Values --> Round Time
请参考屏幕截图
数据透视表可以根据需要使用可调整的列进行重新排列。这是一个示例。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
编辑于
相关文章
Related 相关文章
- 1
数据透视表宏Excel
- 2
数据透视表最新数据Excel
- 3
以编程方式构建Excel数据透视表
- 4
Python熊猫模仿Excel数据透视表
- 5
Excel：数据透视表不筛选
- 6
Excel VBA数据透视表ShowDetails
- 7
Excel数据透视表的SQL日期格式
- 8
数据透视表中的Excel错误栏
- 9
Excel数据透视表-每天平均
- 10
Excel VBA数据透视表ShowDetails
- 11
使用Excel创建简单的数据透视表
- 12
以编程方式构建Excel数据透视表
- 13
Excel：数据透视表不筛选
- 14
Excel 数据透视表滚动计算列
- 15
Sumif 到数据透视表 (Excel 2016)
- 16
Excel 数据透视表递归层次结构
- 17
如何使Pandas中的数据透视表的行为类似于Excel中的数据透视表？
- 18
如何获取Excel数据透视表中的行数以在数据透视表之外使用？
- 19
数据透视表数据
- 20
Excel：确定数据透视表数据的来源
- 21
Visual Studio Excel数据透视表不显示数据
- 22
数据丢失时的Excel数据透视表过滤器
- 23
Excel自定义列表对数据透视表的数据透视字段（列）进行排序
- 24
刷新在Excel Vba中创建的数据透视表（ADODB连接）
- 25
获取选定的数据透视表名称-Excel VBA
- 26
数据透视表-计算唯一值-Excel 2010
- 27
Excel：数据透视表未显示所有字段
- 28
使用数据透视表将Excel报告制作为SSRS
- 29
Excel条件格式会随着数据透视表而扩展？
我来说两句