Custom Filtering

[jcl408]

In Column B I have headers with a bunch of data under them, followed by other headers. So for example,

BLUE WIDGETS
Blue Widgets Data
Blue Widgets Data
Blue Widgets Data
Blue Widgets Data
Blue Widgets Data
RED WIDGETS
Red Widgets Data
Red Widgets Data
Red Widgets Data
Red Widgets Data

and so forth

Is there a way to have a sort at the top that ignores the data and just captures the headers, so when the dropdown comes it is just "Blue Widgets / Red Widgets" instead of everything that is under it?

 

[jcl408]

^