Dude, just learned this trick—use UNIQUE() to list all your categories first, then FILTER() for each one.
Like:
`=UNIQUE(C:C)` to get all categories, then
`=FILTER(A
, C:C=G1)` where G1 is your first category.
Copy-paste the formula for each category. Not fully automatic but way faster than doing it by hand!
Like:
`=UNIQUE(C:C)` to get all categories, then
`=FILTER(A
, C:C=G1)` where G1 is your first category. Copy-paste the formula for each category. Not fully automatic but way faster than doing it by hand!