How to do a group in a report that is based on multiple user name form fields

[Dusty_H]

I have a custom form that has multiple Typeahead fields referencing users. (user1; user2; user3) I have a report but i want to group them by the user names.

So if there were 4 instances of John H. it would group them together no matter if his name was entered in some or all of those custom fields (user1, user2 or user3).

is there a way to do this?

[CalvinFold]

I have an idea, but it is clunky (using a CONCAT field, then a calculated field using CONTAINS); I want to see if the Community has something easier or more direct.