How do I reformat my table?

[LogUx]

Hello Splunkers!!

As per my requirement my current results are as below :

severity	Vulnablities
Critical	3
Medium	4
Low	6

But my expected results are like:

Critical	Medium	Low
3	4	6

Please help me how can I achieve the expected results. 

[ITWhisperer · Accepted solution]

| transpose 0 header_field=severity column_name=severity
| fields - severity

[LogUx]

  @ITWhisperer  My results looking not expected. Please help me how to fix it.

IMG_20221023_215005__01.jpg

[ITWhisperer]

You will have to show what spl you have used in order for me to make any suggestions as to what to change.

[LogUx]

@ITWhisperer Thanks for your suggestion. I will try once I will resume the work let you know.

[LogUx]

@ITWhisperer Thanks for your valuable response, I was away from the work from last few days. Once I will come across with that query I will let you know.

Thanks