Colleague | TEAM | Course id 123 | Course id 124 | Course id 125 | Course id 126 | Course id 127 | Course id 128 |
Colleague 1 | TEAM A | Successful | Successful | Successful | Successful | Successful | Successful |
Colleague 2 | TEAM B | In Progress | In Progress | Not Registered | Successful | Successful | In Progress |
Colleague 3 | TEAM C | Not Registered | Successful | Not Registered | Not Registered | Not Registered | Not Registered |
Colleague 4 | TEAM D | Successful | In Progress | Successful | Successful | Successful | Successful |
Colleague 5 | TEAM A | In Progress | Not Registered | In Progress | In Progress | In Progress | In Progress |
Colleague 6 | TEAM B | Not Registered | Successful | Not Registered | Not Registered | Not Registered | Not Registered |
Colleague 7 | TEAM C | Successful | In Progress | Successful | Successful | Successful | Successful |
Colleague 8 | TEAM D | In Progress | Not Registered | In Progress | In Progress | In Progress | In Progress |
Colleague 9 | TEAM A | Not Registered | Successful | Not Registered | Not Registered | Not Registered | Not Registered |
Colleague 10 | TEAM B | Successful | In Progress | Successful | Successful | Successful | Successful |
Colleague 11 | TEAM C | In Progress | Not Registered | In Progress | In Progress | In Progress | In Progress |
Colleague 12 | TEAM D | Not Registered | Successful | Not Registered | Successful | Successful | Not Registered |
Colleague 13 | TEAM A | Successful | In Progress | Successful | Successful | Successful | Successful |
Colleague 14 | TEAM B | In Progress | In Progress | In Progress | In Progress | In Progress | In Progress |
Colleague 15 | TEAM C | Not Registered | Not Registered | In Progress | Successful | Not Registered | Not Registered |
Team A | Course id 123 | Course id 124 | Course id 125 | Course id 126 | Course id 127 | Course id 128 | |
Successful | |||||||
In Progress | |||||||
Not Registered | |||||||
Team B | |||||||
Successful | |||||||
In Progress | |||||||
Not Registered | |||||||
Team C | |||||||
Successful | |||||||
In Progress | |||||||
Not Registered | |||||||
Team D | |||||||
Successful | |||||||
In Progress | |||||||
Not Registered |
<tbody>
</tbody>
I am new to using pivot tables but i have my data set at the top and would like the table at the bottom to be produced.