Name your data (without any headings) d and the Yes/No range Question and then enter the following array formula to a separate sheet:

=IFERROR(INDEX(d,SMALL(IF(Question="No",ROW(d)-CELL("row",d)+1),ROWS($1:1)),COLUMNS($A:A)),"")

Please note that this (array)formula must be entered by holding down Ctrl and Shift before pressing Enter.
Copy the formula to the right and downwards as required.

The names d and Question are not absolutely required. I have done it because I find it convenient, but you can, if you prefer, use the actual ranges instead. The formula will then be longer.