I'm sure there is a simple function for this.

I have a master list of items in my far left column. The columns to their
right use various combinations of the masterlist for which I have placed an X
within the column in line/the row of the masterlist on the left.

How do I get the program to sort or eliminate both the items or rows not
with an X from the master list on the left along with eliminating from view
all the other columns but the one selected?

I want to be able to print individual reports showing how each individual
column matchs up with the master list. HELP