Extract & Categorize from Master Tables Into Multiple Tables

Hi

I'm assuming this is possible some how

I have a Master Table with Categories & Skills.

I'm looking to extract or categorize into multiple other tables

Looking for a less manual process other than filtering, copying & pasting

I think an Index type of function would work but not sure how

See example tables

Thanks