Return multiple categories in a single row & single column
Solution 1:
Use below
select store, string_agg(category, ', ') category
from your_table
group by store
if applied to sample data in your question - output is
Use below
select store, string_agg(category, ', ') category
from your_table
group by store
if applied to sample data in your question - output is