I have a spreadsheet for a festival. Unique identifier is ticket number. I want to query the column with tent number, to automatically generate two columns. First column has tent number. Second column has total number of occurrences of that tent number.
I want Column K and L to autogenerate tent number and number of occupants based on column J. How can I do this?