I've inherited a big Sharepoint list of live data. It's rows of people then columns if training and other stuff its 350 columns wide by 5000 rows... I'm over faced by the numbers 😯
All the columns
| Name | Training 1: date | Training 1: Status | Training 2: date | Training 2: Status | Training 3: date | Training 3: Status | Training 4: date | Training 4: Status |
| Bob | etc.. | Overdue | etc.. | Overdue | | Overdue | | Complete |
| Anne | | Overdue | | Overdue | | Overdue | | Overdue |
| Claire | | Overdue | | Complete | | Due | | Overdue |
| Simon | | Overdue | | Overdue | | Due | | Complete |
| Sarah | | Complete | | Overdue | | Due | | Overdue |
| pat | | Complete | | Due | | Complete | | Overdue |
| Chris | | Complete | | Complete | | Complete | | Complete |
I want to see the data in 2 ways
1. What's due in a number summary
| Training | Due | Overdue | Total |
| Training 1 | 0 | 4 | 4 |
| Training 2 | 1 | 4 | 5 |
| Training 3 | 3 | 2 | 5 |
| Training 4 | 0 | 4 | 4 |
2. Needs training:
| Training 1 |
| Bob |
| Anne |
| Claire |
| Simon |
