Data is seemingly arbitrarily split into two columns in the pivot table, and I can't figure out why. In the purple worksheet "Lecturer totals T1" you'll see two columns for "All". On "Lecturer totals 01-17" you'll see "BaL" and "HLS" twice. On "Lecturer totals T2 & 3" there are two columns for each of "All", "BaL" and "HLS". On the green "Faculty totals T1" worksheet, "All" has two entries. There are similar cases in the other worksheets.
I've tried applying the "=ISNUMBER" function to each of the cells containing "All" in the data (the red worksheets). These return a FALSE reading, which (if I understand correctly) means that they're text, which is what they should be.
Depending on when you answer, I might not be able to continue the conversation before tomorrow around 0900.
Solved by Z. Y. in 29 mins