# Split columns in a table

**URL:** https://discuss.elastic.co/t/split-columns-in-a-table/49184
**Category:** Kibana
**Created:** [May 4, 2016, 2:00pm UTC](https://discuss.elastic.co/t/split-columns-in-a-table/49184 "2016-05-04T14:00:13Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [May 4, 2016, 3:04pm UTC](https://discuss.elastic.co/t/split-columns-in-a-table/49184/2 "2016-05-04T15:04:38Z")

</div>

Not sure if this will work for your use case:

First, split rows using a terms aggregation on your string field. Then, split table (columns) using a terms aggregation on your integer field.

The metric will be count.

---

_[View the full topic](https://discuss.elastic.co/t/split-columns-in-a-table/49184)._