I am running search against a database that includes a username and ticket count (from our ticketing system). When the results come back, I have one user who is listed with multiple iterations of their name. For example:
Username Count
John Q User 5
John Quser 3
John User 6
These are all the same user, so I would like to combine the names into a single entry (as "John Q User"), and combine the counts for each entry to reflect (from the above example) the total count of 14.
Any help would be very much appreciated.
... View more