# How to display Column Data as headers (Transpose Data Table)

**URL:** https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738
**Category:** Kibana
**Created:** [March 20, 2018, 11:09am UTC](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738 "2018-03-20T11:09:18Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sahadevgd](https://avatars.discourse-cdn.com/v4/letter/s/6f9a4e/32.png) [@sahadevgd](https://discuss.elastic.co/u/sahadevgd)
#### Post date: [March 20, 2018, 11:09am UTC](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738/1 "2018-03-20T11:09:18Z")

</div>

Hi Team,

I'm working on Kibana 6.0. I'm feeding data via logstash and my data is in csv format.

My Data:  
Time,Status,ServiceName  
2018-03-15 15:30,Up,FETCH  
2018-03-15 15:30,Up,UPDATE  
2018-03-15 15:30,Up,DELETE  
2018-03-15 15:31,Up,FETCH  
2018-03-15 15:31,Up,UPDATE  
2018-03-15 15:31,Up,DELETE  
2018-03-15 15:35,Up,FETCH  
2018-03-15 15:35,Up,UPDATE  
2018-03-15 15:35,Down,DELETE

with the above data, i have my data table as the same with Time,Status,ServiceName as column names and values as the respective column data.

My requirement here to have below:

![Untitled](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1a7d68947724e1c60c31f306620654d336008441.png)

I would be having time as column names (dynamically) and rest of the data as shown.

Please let me know if this is possible and how can we achieve this type of visualization in Kibana.

Thanks.

---

<div class="post-metadata">

### Author: ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)
#### Post date: [March 20, 2018, 11:30am UTC](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738/2 "2018-03-20T11:30:20Z")

</div>

Hey,

this is unfortunately currently not possible. Please follow ticket [#3620](https://github.com/elastic/kibana/issues/3620) for updates about transposing tables.

Cheers,  
Tim

---

<div class="post-metadata">

### Author: ![sahadevgd](https://avatars.discourse-cdn.com/v4/letter/s/6f9a4e/32.png) [@sahadevgd](https://discuss.elastic.co/u/sahadevgd)
#### Post date: [March 21, 2018, 9:13am UTC](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738/3 "2018-03-21T09:13:17Z")

</div>

Hi,

thanks for your response.

I'll follow the thread for more updates.

Thanks,  
Sahadev

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 18, 2018, 9:13am UTC](https://discuss.elastic.co/t/how-to-display-column-data-as-headers-transpose-data-table/124738/4 "2018-04-18T09:13:19Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.