I have a table of a lot of items’ sales per location (pivoted). Can I group some of the items in the column.
Instead of having jeans, t-shirts, baseball caps(headwear), beanies (headwear), sweaters, visors (headwear) I’d like the column to be jeans, t-shits, sweaters, headwear (all items).
Thanks for your help, probably an easy one!