I have two tables in separate tabs.

The first holds all information about my projects with a column with a yes/no option. Those that fulfil the yes criteria are fed into my second table via an IF formula. However, this means that those that ='no' show but as blank cells.

Is there a way of transferring over the data I need whilst ignoring the blanks? Or perhaps something I can do afterwards to delete the blanks as new data is filtered in?

Thanks