I've created a google form for review of officials at sporting events. A comment is required if the official gets a score of 1 or 2 in any section. Additionally, an optional comment section is also available.
I've created a sheet to calculate averages for each official that is reported on. How do I list the comments that are given for each official? I'm assuming there will be more than one comment for each.
I currently have a pivot table but would prefer the comments and rating to be listed together if possible.
On the summary sheet, columns K and L are just me trying different things.
Bookmarks