I have an excel spreadsheet in which I have created a table. I have a heading called "Location" which I have applied filters to. When I click the checkbox on this heading which allows me to apply filters I notice I have two values of "South Pavillion". How do I fix so there is only one?
Please take a look at the screenshot :
In the filters drop down menu (which I have not provided a screenshot of) South Pavillion is shown twice.