Autofilter allows you to filter data and easily select it from a dropdown box. Unfortunately, it's limited in that it only allows you filter on data within a column and in different rows. I'm wondering if anyone knows a way to do this on data within the same row but to display only the columns that fit a certain criteria.

For example, if I have the following table:
\1

is there any way to create some sort of drop down box to allow the user to only view those columns where criteria C = 1 or C = 2 or whatever the user decides?

thanks.