I have a workbook with 2 worksheets. Wksht 1 = Checklist, Wksht 2 = Completion.

In cloumn A (Wksht1) I have a list of Y or N for range A2:A14 and column B
is a range of Items. eg:

COL A COL B
Y LOCAL
Y HIGHWAYS
N MINING
Y DRAINAGE

In column A (wrksht 2) I have the following formula:

=IF(Checklist!A2= "Y",Checklist!B2," ")
I then copied this down the column to othe rows

Where the logical test is true I do get the correct value from col B
but if the logical test is false then I just get a blank line.

How do I get rid of the blanklines and end up with just the 'true' values.