# How to Flatten a vertical Array (plugin use)

**URL:** <https://community.glideapps.com/t/how-to-flatten-a-vertical-array-plugin-use/34111>\
**Category:** Ask for Help\
**Created:** [November 6, 2021, 12:06pm UTC](https://community.glideapps.com/t/how-to-flatten-a-vertical-array-plugin-use/34111 "2021-11-06T12:06:46Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 6, 2021, 2:53pm UTC](https://community.glideapps.com/t/how-to-flatten-a-vertical-array-plugin-use/34111/6 "2021-11-06T14:53:59Z")

</div>

Nice, but you have a couple of extra columns that you don’t need. Once you have your Unique items, then you only need two more columns:

- the equivalent of your begin column, except start the numbering at zero
- a single value column, that takes “begin” from start, from the unique column.

Here is a contrived example to show what I mean:

 ![Screen Shot 2021-11-06 at 10.52.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/05fe219bf2159b0a685c1a716cce7754ffa3581e.png)

 ![Screen Shot 2021-11-06 at 10.52.45 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/84fc3efbf104a5c5b6b05e2106a5d2429c1edd3f.png)

---

_[View the full topic](https://community.glideapps.com/t/how-to-flatten-a-vertical-array-plugin-use/34111)._