pivot table duplicate drop down

I have a strange situation which I have been unable to resolve. I have a single database, no queries or connections, everything located in a single table on a single sheet. From this, on 5 tabs, I have individual pivot tables. 4 of them work perfectly. One is driving me insane. This is a screen clip of the pivot table. The issue is the licensee field and the drop down sort.

Here is what the sort looks like:

Every licensee name is duplicated. The immediate suspicion was some kind of spelling error or extraneous characters or trailing spaces. But two things 1) the other four pivot tables don't have this problem and they use licensee and 2) I replaced the name field with proper(trim(cellname)) to ensure they were cleaned up.

So I created a new pivot table, new sheet, with ONLY the licensee field

And look at the drop down

Not only are the dups still there, but that one record "13Avenue Liquor Store" was fixed in the master database, and doesn't update.

I am clearly missing something obvious about underlying data in the pivot table, but I have no idea what. Some kind of sand is in the gears if 4 tables show this field perfectly correctly, and another refuses to.

The only possible lead I have is that at one point in my pivot table creation, Licensee was a filtered field. I decided to move it to the actual pivot table and use it as drop down filtering instead. I did not do this with the other tables. But that wouldn't explain why I cannot create a new table that works properly.

Hints?