Can someone help me with the pivot in below format
Raw Data
| Name | Owner | Role | Can Edit | Can Read | Can Delete | Can download |
|---|---|---|---|---|---|---|
| John | Julan | Role1 | Yes | No | No | No |
| Ricard | Julan | Role2 | No | Yes | No | No |
| Sam | Hannah | Role2 | No | No | Yes | No |
| Julia | Hannah | Role1 | No | No | No | Yes |
| Katie | Julan | Role2 | No | Yes | No | Yes |
Output looking for is
| Role1 | Role2 | |||||
|---|---|---|---|---|---|---|
| Owner | Name | Can Edit | Can Read | Can download | Can Read | Can download |
| Julan | John | Yes | No | No | - | - |
| Richard | - | - | - | Yes | No | |
| Katie | - | - | - | Yes | Yes | |
| Hannah | Julia | No | No | Yes | - | - |
| Sam | - | - | - | No | No |
