Create table with specific criteria from another table

Hi Erin,

Welcome to the community!!

Are you looking for something like this?

Regards
Piet