# How can I change the rows and columns of a table?

**URL:** <https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961>\
**Category:** Kibana\
**Created:** [November 1, 2018, 5:32am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961 "2018-11-01T05:32:41Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 1, 2018, 5:32am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/1 "2018-11-01T05:32:41Z")

</div>

![%EC%BA%A1%EC%B2%981](https://us1.discourse-cdn.com/elastic/original/3X/2/f/2f07c0e395ab6e188e07e32c3b0eb33213a0000f.png)

How can I change the rows and columns of a table?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [November 1, 2018, 5:34am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/2 "2018-11-01T05:34:57Z")

</div>

In the `Buckets` section, you should just be able to reverse the aggregation order.

if it's still not clear, post a screenshot of your visualisation config.

---

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 1, 2018, 5:43am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/3 "2018-11-01T05:43:27Z")

</div>

![%EC%BA%A1%EC%B2%982](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7d78f74c23689879d8de17503c0c0e5ae56f6872.png)

it's stil not clear ;;

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [November 1, 2018, 5:46am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/4 "2018-11-01T05:46:44Z")

</div>

Add another sub-bucket and then use `Split Columns` and see if that helps.

---

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 1, 2018, 5:52am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/5 "2018-11-01T05:52:25Z")

</div>

![%EC%BA%A1%EC%B2%983](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3c1d534f633fa89c9c8e6d91291e8120714d7f9d.png)

like this?? but it's too dirty..;;

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [November 1, 2018, 5:59am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/6 "2018-11-01T05:59:12Z")

</div>

Hmm, maybe I am totally mistaken then. Hopefully someone else can pop in and provide a comment.

---

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 1, 2018, 6:00am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/7 "2018-11-01T06:00:08Z")

</div>

okay, thank you.

---

<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:** [November 29, 2018, 6:00am UTC](https://discuss.elastic.co/t/how-can-i-change-the-rows-and-columns-of-a-table/154961/8 "2018-11-29T06:00:23Z")

</div>

Closed on November 29, 2018, 6:00am UTC

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