I have a table with formatted something like this:
1 John, Smith, a123, superuser, blah 2 John, Smith, a123, audit user, blah 3 Sally, Smith, a234, regular user, blah 4 Andy, Smith, a345, audit user, blah 5 Andy, Smith, a345, log user, blah 6 Andy, Smith, a345, super user, blah
When you run the lookup for the user id (so like a123), you get both results on two lines within the same box in the table.
I want one single line that has the user type concatenated. So instead of: a123, super user a123, audit user
I want: a123, "super user, audit user"
Is that possible?
... View more