Transpose from one sheet to the next and leave out blank cells
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.
|