I have a spreadsheet where each row is a persons choice of colour and size of a T-Shirt. It looks something like this: Large     Red    Small     Blue   Medium    Red    Small     Red    Medium    Red   I'd like to be able to summarise that in a form I can give to a supplier, ideally like this: Large   Red   1  Medium  Red   2  Small   Blue  1  Small   Red   1 What's the best way to do this?
Google sheets: How do I do a group count on 2 fields, to summarise colour and size choices
google spreadsheets