How can I use Google Sheets to separate data by a specific value? or What's the best way to separate

OP reply:
Wow, thanks for all the ideas! I tried FILTER() and it worked like a charm for the first few categories.

But now I’m stuck—how do I handle like 20+ categories without making a million formulas? Apps Script sounds scary, but maybe I’ll give it a shot.

Also, Coupler.io looks dope—gonna check that out. Y’all are legends!

(And yeah, updated the title—way clearer now.)