In the process of building a house, I developed a spreadsheet showing each
room on the Y-axis and each trade eg Electric, plumbing etc as columns, with
the features for each room eg light fixtures, faucets enterd in the
respective columns. I now would like to select and print for each trade,
their respective part's list by room and eliminate all the blank cells in the
electric column.

In other words, how do I select only the rows where there is data in the
electric column's cells, and print this report for the electrician?