我有类似以下的数据
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