I have a summary tool that transforms the data in the format in the attached image. I would like to get the data transformed to my desired result but have not been able to figure out how. Is this possible?
| Summary Tool: | | | |
| Term | Schoolname | Apps | Admits | Deposits |
| Fall 2020 | School 1 | 116 | 34 | 1 |
| Fall 2020 | School 2 | 1311 | 448 | 2 |
| Fall 2020 | School 3 | 450 | 151 | 1 |
| Fall 2021 | School 1 | 200 | 50 | 2 |
| Fall 2021 | School 2 | 1300 | 450 | 3 |
| Fall 2021 | School 3 | 399 | 125 | 2 |
| Desired Result: | Fall 2020 | Fall 2021 |
| Schoolname | Apps | Admits | Deposits | Apps | Admits | Deposits |
| School 1 | 116 | 34 | 1 | 200 | 50 | 2 |
| School 2 | 1311 | 448 | 2 | 1300 | 450 | 3 |
| School 3 | 450 | 151 | 1 | 399 | 125 | 2 |
