Forum Discussion
Create a report to display a volunteer's event attendance history
I have a spreadsheet that tracks volunteers and the events they participate with a form that repots each individual volunteers' information. I need to gather and display each event the volunteer attended. For example.
The data looks like this:
| Volunteer | Date | Event |
| Batman | 1 may 22 | Gotham City Cleanup |
| Wonder Woman | 3 may 22 | Tree planting |
| Batman | 5 may 22 | children's hospital opening |
| Batman | 10 may 22 | Food drive |
| Superman | 5 may 22 | High rise repainting |
The output would look like this:
| Batman |
1 May 22. Gotham City Cleanup. 5 may 22, Children's Hospital Opening 10 May 22, Food Drive |
I'm sure the answer is simple and staring me in the face, I just can't see it. Thank you in advance.
cobra240 I would use a pivot table. Some examples in the attached file.
