I wanted to do a pivot table as shown below.
Clearly it is not correct, as Business is the most popular subject and it shouldnt have any "<0 or (blank)".
I am assuming that the problem here is that I haven't sorted out my data. But which column should I sort (before creating the table)?
I tried to use the Business column, then REFRESHED my table,
It is still rubbish.