I have a spreadsheet that has addresses down column A and Types of
inspections across Row 1. The rest of the table is filled with the dates
that the inspections have passed. I need to be able to generate a list of
the inspections that passed for a given month. That list should include the
address, the inspection type and the date the inspection passed. For a given
month there may be multiple inspections that passed for a single address. I
would like them reported in individual lines. Using index, small and IF I am
able to get part of it done, but I just cant seem to get all the data to
report in the same order.

Any help is greatly appreciated.
Steve