How do I consolidate the values returned from a database query into a single entry?

[edpeyregne]

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.

[edpeyregne]

I finally found this in another post"

http://answers.splunk.com/answers/61646/combining-multivalues-together-inside-a-field.html

Thanks for the response Rich!

[richgalloway]

Is there another field (like email address) available from the database that would link common entries?

[edpeyregne]

Unfortunately, no.