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

If you’re lazy like me, just use the "Data" > "Split text to columns" feature.

It’s not perfect for complex splits, but for quick fixes, it’s a lifesaver.

For your title, maybe "Best way to split Google Sheets data by category?" Sounds cleaner imo.