Missing drop-down options in my filter selections. Where did they go?


I have been creating filters and for some reason a couple of my drop-down options are not showing up as filter selections, even though they are correctly showing up as drop-down options in the sheet. To illustrate, here are the drop-down options I have for a column in my sheet, which are working correctly:

but when I try to create a filter for a particular drop-down selection, for some reason the selections skip from option 1 to option 4, 5, 6... (i.e., no D2 or D3)

Anyone have any insights/help for me? Thanks.

Best Answer