The screenshot I posted was an example of what I wanted it to look like, this is what I have currently

Lawson02, there's not a way to make these iterated lists be clickable that's the downside of needing textmode for expressions to pull data. But I wonder if you could do a shared column with one column being your textmode and a second column being the category name and you could use advanced options to do formatting where text says Click Here for that category name field. So it would look something like this once merged. Here's link to shared col setup, https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/view-merge-columns. Again, its a thought, I've never done this with category name but I have with other fields.
Sampling Form
CLICK HERE