Hello. I have a search that results in, amongst other things, fields that are ALMOST duplicates. Example: Bob: Task incomplete. Steve: Task Incomplete. George: Task Incomplete. Fred: Task Complete. Spock: Task Complete. Is there a way to generate a table which results in: | Task Status | Team Player Responsible | | Task Complete | Fred, Spock | | Task Incomplete | Bob, Steve, George | For each instance of "Task Complete" and "Task Incomplete", I want to know which Persons to tag in a simple table without listing every user in a giant list. I've looked into dedup, uniq and sub-searches but haven't figured out how to list the non-duplicated parts next to a single instance of the duplicated part. [Insert deity], I hope that made sense. Help?
... View more