How to filter multiple columns with single fliter drop-down arrow

[dinosaur143]

Hi, I'll post example pictures to explain better, but I'm getting very frustrated... It seems like such a simple thing to do but I cannot figure it out.
I want to be able to filter for specific values in all the columns underneath a merged cell group. I used a simplified example of just "Letters", because my data is proprietary and large, but the format is the same.

EDIT: Removed garbage image code - Moderator

When I use the filter, it only filters the first column. As shown below, it doesn't even recognize that there are 'c' and 'd' values.

EDIT: Removed garbage image code - Moderator

So what I want to happen is with that single filter, I can filter the data for any value contained in all the columns (in this example columns A - D), and it will find that value in any row. In this example, filtering for 'a' should have given me all the rows back because they each had an 'a' value in them.

Thanks for any help you can give me.

 

[Smitty]

Welcome to the Board!

Note that I removed the image code that you posted as it wasn't rendering. You can try the Board's HTML Maker to post a shot(s) of your sheet, just follow the link in my sig.