How can I transpose/transform data in multiple rows?

[quahfamili]

Hi all,

I was preparing my data to be visualised. However, I met with a challenge. The below is an extract of my data:

My desire output would be:

Note that the key value is dynamic, there could be 10 to 20 numbers of keys.
Anyone has any idea to achieve this?

Thanks in advance!

[vnravikumar · Accepted solution]

Hi

Try this

your query... 
| table key,value,field1,field2 
| eval {key}=value 
| fields - key, value 
| table *

[quahfamili]

Hi it works, 1 more question for {} how do i control the numbers of keys? it seems like defaulted at 24 columns.