Condensing multiple table rows into one row

[willial]

I'm working with a database as my source (through DB Connect) and performing a bunch of different evals. When I go to output it looks like this:

**username      JanTotal   FebTotal   MarTotal**
user1            5
user1                         12
user1                                    8
user2            1
user2                         6
user2                                    3

And so on for multiple users. Try as I might, I can't get it to display simply as:

user1            5            12         8
user2            1             6         3

Is there an easy way to condense these rows into a single row by username? I'll even take a hard way.

[somesoni2 · Accepted solution]

You can try stats. something like this

your existing search (with output 1 above) | stats first(*) as * by username

[willial]

Works perfectly! Thanks!

[martin_mueller]

Yup, stats first(*) as * by username is the way to go as long as each field only has up to one value per username.