How to divide a worksheet so the dropdown menu is separated per column

[nsa1]

Hello,

I want to set a middle column between two adjacent column (left and right of middle empty column) to separate both left and right column in a way so if one column row filter is separate from the another column row filter.

For example in the following snapshot, I want to have Col B to make Col A and Col C separated so, that if I do dropdown filter on Col A then Col B remains the same and Vise Versa.

thanks,

NA

 

[nsa1]

Can anyone help here?

 

[dreid1011]

Can anyone help here?

You could make each range its own table. Each table would be sortable on its own. Otherwise, I don't think you can apply the filter and skip columns the way you want to, you either filter one column at a time, or you apply the filter to both.