How can I view all comments from a curated group of rows?


Here is my scenario: the regulatory staff on my team are transitioning to a smartsheet-based tracker to keep track of all regulatory tasks related to a clinical trial.

Each task (initial applications, protocol amendments, personnel changes, continuing reviews, etc) has its own row. In other words, one trial may have 10 to 100 different regulatory tasks / rows represented.

If there are 25 comments over 25 different rows that are associated with the same trial - is there a way that I can curate all of those comments into a report?

Thanks for any ideas.