Hi there ,
I have a dataset that looks like the below
| Programme | Level | Year | Outcome | Total Attrition % | Headcount |
| Sport | Level 4 | 2020/1 | Fail | 97% | 65 |
| Sport | Level 4 | 2020/1 | Transfer | | 7 |
| sport | Level 4 | 2020/1 | Withdrawn | 3% | 2 |
| Sport | Level 4 | 2020/1 | Total Attrition | 13% | 67 |
| Sport | Level 4 | 2021/2 | Fail | 80% | 25 |
| Sport | Level 4 | 2021/2 | Transfer | | 3 |
| Sport | Level 4 | 2021/2 | Withdrawn | 20% | 8 |
| Sport | Level 4 | 2021/2 | Total Attrition | 12% | 33 |
I have hundreds of rows of data for various programmes and I tried filtering on the year and creating the table separately then appending the two columns (labelling them attrition % 2020/1, Headcount 2020/1 as below). This worked where I had three different programmes, but now that I am attempting it with several hundred, it is not showing the correct figures for the appended year. Any advice is appreciated.
This is the end table I'm aiming for.
| Programme | Level | Outcome | Total Attrition % 2020/1 | Headcount 2020/1 | Total Attrition % 2021/2 | Headcount 2021/2 |
| Sport | Level 4 | Fail | 97% | 65 | 80% | 25 |
| Sport | Level 4 | Transfer | | 7 | | 3 |
| sport | Level 4 | Withdrawn | 3% | 2 | 20% | 8 |
| Sport | Level 4 | Total Attrition | 13% | 67 | 12% | 33 |
