I have an inventory table listing equipment for different areas. I also have Control Logs for each area that pulls that areas designated equipment from the Inventory Table. Each area has its own set of equipment (i.e. Area 1 has 1-A, 1-B, 1-C...; Area 2 has 2-A, 2-B, 2-C...) but certain equipment is either missing (designated by a blank cell) or is damaged (designated by an X). How can I get the Area Control Logs to list all the available equipment in a column while skipping over the blanks and the X's in a single column?
Right now, the Area Control Logs show the inventory list as:
1-A
1-B
X
1-D

1-F

I would like it to show on the Area Control Logs like this:
1-A
1-B
1-D
1-F