# Create an array from table values

**URL:** <https://community.parabola.io/t/create-an-array-from-table-values/1554>\
**Category:** Ask a question\
**Created:** [February 10, 2021, 8:10pm UTC](https://community.parabola.io/t/create-an-array-from-table-values/1554 "2021-02-10T20:10:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian1](https://avatars.discourse-cdn.com/v4/letter/b/50afbb/32.png) [@Brian1](https://community.parabola.io/u/Brian1)\
**Post date:** [February 10, 2021, 8:10pm UTC](https://community.parabola.io/t/create-an-array-from-table-values/1554/1 "2021-02-10T20:10:58Z")

</div>

I’m trying to update the drop-down (PICKLIST) options in a Smartsheet column with the values from another column using the Smartsheet API. Is it possible to create a flattened list and then convert to an array from values in a table?

 ![picklist](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/9/9d31bd231409863872037945d1ab75d8e55b3e91.png)

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [February 11, 2021, 12:00am UTC](https://community.parabola.io/t/create-an-array-from-table-values/1554/2 "2021-02-11T00:00:21Z")

</div>

Hey @Brian1 👋,

The [Insert Text Column](https://parabola.io/transform/insert-text-column) step is the first step to formatting your array. You can wrap the values in your cell with quotes or square brackets. To wrap each value in your `Truck Number` column in quotes, add `"{Truck Number}"` as the text.

You can flatten the values in your `Truck Number` column using the [Merge duplicate rows](https://parabola.io/transform/merge-duplicate-rows) step. Merge the values in your `Truck Number` column using a comma delimiter per unique value in another column, like `Index`.

Here’s a basic framework of what that might look like:

 ![flatten-array](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/5/5b11c8830821d831baf240fba797beb5d75bf1de.png)

Hope that helps!

---

<div class="post-metadata">

**Author:** ![Brian1](https://avatars.discourse-cdn.com/v4/letter/b/50afbb/32.png) [@Brian1](https://community.parabola.io/u/Brian1)\
**Post date:** [February 11, 2021, 2:05am UTC](https://community.parabola.io/t/create-an-array-from-table-values/1554/3 "2021-02-11T02:05:43Z")

</div>

That worked great, thank you for the rapid response! Next step is to figure out how to get a Smartsheet webhook configured.