At my school, we have a Google Form for recording classroom discipline. The form generates the standard spreadsheet. I want a list of how many times each unique student has received a disciplinary action. It would be great if it can be broken down by Discipline (i.e., how many Silent Lunches and PE Detentions John Doe gets) but even just something that says
John Doe, 6 is great.
I would like this information in either a separate worksheet/table or at least in a new column. I've looked and found a lot of information about count function, queries, arrays, etc., but I can't tweak the parameters of what I've found to the point where I get what I need.