# Split arrays into columns?

**URL:** <https://community.glideapps.com/t/split-arrays-into-columns/13589>\
**Category:** Ask for Help\
**Created:** [August 5, 2020, 8:12am UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589 "2020-08-05T08:12:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\
**Post date:** [August 5, 2020, 8:12am UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589/1 "2020-08-05T08:12:20Z")

</div>

If there are multiple answers to one question and they come in as item1, item 2, item 3, from the form, is it possible to keep that column for display purposes and also split them into individual array columns to be used for filtering, grouping, etc?

I currently do the reverse by concatenating the array columns together, but am unsure how to do it the other way.

Moving forward I would have them select each role individually, but for the users who signed up via email list I would have to do this manually to split them apart. Any assistance would be great.

Thanks!

Thanks!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 5, 2020, 12:38pm UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589/2 "2020-08-05T12:38:33Z")

</div>

You can still point to individual columns for components. Glide just displays the array in the editor so you know that it can be used as an array.

---

<div class="post-metadata">

**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\
**Post date:** [August 5, 2020, 1:15pm UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589/3 "2020-08-05T13:15:28Z")

</div>

In this case I am trying to go from job1, job2, job3 all in one column to displaying it in 3 columns without having to manually cut and paste each one or retype. Is there a formula for that?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 5, 2020, 1:16pm UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589/4 "2020-08-05T13:16:44Z")

</div>

Use a SPLIT formula in the sheet. Preferably in combination with an array formula.

---

<div class="post-metadata">

**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\
**Post date:** [August 5, 2020, 1:19pm UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589/5 "2020-08-05T13:19:23Z")

</div>

The info came from a form where I allowed them to choose multiple choice, so it did not have an array formula originally. Is there anywhere I can see this? I will also do a search. Thanks for your help.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 5, 2020, 2:01pm UTC](https://community.glideapps.com/t/split-arrays-into-columns/13589/6 "2020-08-05T14:01:11Z")

</div>

The Google form isn’t going to write the arrayformula for you. You need to add it yourself, but the arrayformula will contain a split formula to split each value into separate columns based on a comma delimiter.