# Transpose data table in Kibana

**URL:** <https://discuss.elastic.co/t/transpose-data-table-in-kibana/60188>\
**Category:** Kibana\
**Created:** [September 9, 2016, 6:17pm UTC](https://discuss.elastic.co/t/transpose-data-table-in-kibana/60188 "2016-09-09T18:17:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandeeptengli](https://avatars.discourse-cdn.com/v4/letter/s/e99b99/32.png) [@sandeeptengli](https://discuss.elastic.co/u/sandeeptengli)\
**Post date:** [September 9, 2016, 6:17pm UTC](https://discuss.elastic.co/t/transpose-data-table-in-kibana/60188/1 "2016-09-09T18:17:48Z")

</div>

Hi all,

I have a data table with 170+ columns. Is there a way I can transpose the table. I am not sure how to split the rows by 170+ terms.

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [September 12, 2016, 5:19pm UTC](https://discuss.elastic.co/t/transpose-data-table-in-kibana/60188/2 "2016-09-12T17:19:13Z")

</div>

Hi Sandeeptengli,

I'm not sure I understand your question. If you "Split Table" then you can select rows or columns, but when you "Split Rows" you cannot.  
There is this enhancement request. Is it what you're looking for?

> <https://github.com/elastic/kibana/issues/3620>

Regards,  
Lee

---

<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:** [July 6, 2017, 1:39pm UTC](https://discuss.elastic.co/t/transpose-data-table-in-kibana/60188/3 "2017-07-06T13:39:06Z")

</div>