我有類似下面的數據
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