Transposing Rows to Columns in Kibana Data Table Visualization

Hello Kibana community,

I am currently working on visualizing data from my MS Defender AV logs in Kibana, and I'm facing a challenge in presenting the data in the desired format. I have data in the following structure:

I am using a Data Table visualization in Kibana and would like to transpose these rows into columns, making "Host name," "AV security intelligence age," etc., the column headers.

Could someone please guide me on how to transpose rows into columns effectively within Kibana?

Any insights, suggestions, or examples would be highly appreciated. Thank you!

Hi @abhinay_nalla. Can you show the options you've set for your table? A screenshot of the full editor should help.