Hmmmm. You should be able to do this in paginated reporting by adding in the columns. Let me try a bit of testing and get back to you, because I could swear I've done this or something similar to it.

I've tried but it was just not looking right. I ended up just setting up a live connection with Google Sheets and putting a hyperlink to the Google Sheets within the report

Okay, so I found a way that MIGHT work for you.
What I did here was to make one table for each team member (name, affiliation). They are "stacked" on top of each other, so what you see in this image is actually three separate tables.
To get the Team Member column, I just put in a text field, and used some spacers (highlighted so you can see them) to space them out so they'll look right in the PDF.
That's about the best solution I could find. Hope it helps you!