Excel - 数据透视表中的多个字段被视为单个字段

Excel - 数据透视表中的多个字段被视为单个字段

我有类似以下的数据

Forename | Surname | ID | Role
-------------------------------
Jo       | Bloggs  | 1  | A
Jo       | Bloggs  | 1  | B
Jo       | Bloggs  | 1  | C
Mary     | Bloggs  | 2  | A
Mary     | Bloggs  | 2  | B
Mary     | Bloggs  | 2  | C
Mary     | Bloggs  | 2  | D
Mary     | Bloggs  | 2  | E

枢轴旋转将导致以下结果

Details       | A | B | C | D | E
1 Jo Bloggs   | X | X | X |   |
1 Mary Bloggs | X | X | X | X | X

相关内容