I have a table

Y A
Y B
N C
Y D

I need a formula (can't use a macro) to show only column 2 on another sheet
and have it displayed on one row, leaving out the fields with an "N" in the
first column.

A B D <--- this would be my result on the other sheet, one row and three
columns.