Team creator based on a list with different categories

Hi team,

I've got this thing I wanted to do but can't seem to think of a way to do so.

The idea is to create a team generator based on a list with categories. I'm attaching a simplified spreadsheet with the idea and result I wanted.

I would prefer this to be dynamic so formulaes would probably be best.

The idea is to create a team of items based on a category, with each item being only able to be picked once.

Hopefully, this makes sense.

Let me know if this works.

Thank you!

-Zed