transpose but with one column being a group by column

[harshpatel]

Hi,

So at the current state of my search results in following format:

key fieldname   fieldvalue
k1  name1           0 day
k1  name2           N/A
k2  name1           0 day

I want it to be something like following but I am not sure how to achieve this.

key   name1 name2
k1    0 day N/A
k2    0 day       

Thanks,
Harsh

[jpolvino · Accepted solution]

Try putting this at the end:
| xyseries key fieldname fieldvalue