Pick out rows from a range in Google Sheets

Question

In Google Sheets, how can I pick out columns from a range based on the value of another column?

In this example, I want to filter out the plays based on genre, and copy the title and date over to the right.

Answer 1

You can use FILTER()

In F3:

=filter(B3:C,D3:D="Comedy")

In I3:

=filter(B3:C,D3:D="History")

In L3:

=filter(B3:C,D3:D="Tragedy")