help to display field header in ordinate axis

[jip31]

hi

The stats command below allows me to display data in a table panel

I would like to display the fields header in an ordinate axis instead an abcissa axis

could you help me please??

| stats last(Site) as "Geolocation site", last(Building) as "Geolocation building", last(DESCRIPTION_MODEL) as Model, last(OS) as OS by USERNAME

[niketn]

@jip31 can you add some sample data for current output and expected output?

[jip31]

Sort I cant share datas

But instead having the field header at the bottom

A B C D

1 2 3 4

I need the field header on the left

A 1

B 2

C 3

D 4

[to4kawa · Accepted solution]

| makeresults
| eval _raw="A B C D
1 2 3 4"
| multikv
| table A B C D

| eval header="count"
| transpose 0 column_name=cols header_field=header

try transpose