It is possible that Bryce has mis-interpreted your problem.

Do you want to hide the columns so that only the SAT column remains
visible (as I think Bryce is assuming) or do you want to filter the
SAT column to show only the 'Y's or 'N's?

If the latter is the case you could do worse than recording a macro as
you perform the filter you want and then pick through the code and
come back here with a more specific question if you get stuck.

Br, Nick H