# Joined list to Column for colection

**URL:** <https://community.glideapps.com/t/joined-list-to-column-for-colection/78677>\
**Category:** Ask for Help\
**Created:** [December 18, 2024, 3:21pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677 "2024-12-18T15:21:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)\
**Post date:** [December 18, 2024, 3:21pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677/1 "2024-12-18T15:21:17Z")

</div>

Good afternoon everyone.  
Can you help me transform an array made with joined list into a column.  
Example  
Joined List  
Banana,Avocado,Orange.  
Fruits Column  
Banana  
Avocado  
orange.  
Is this possible?

---

<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:** [December 18, 2024, 3:38pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677/2 "2024-12-18T15:38:01Z")

</div>

- Number your rows, starting at 0
- Coerce your list into an array using a Split Text column
- Apply the array to every row using a Single Value-\>First column
- Use a second Single Value column to extract the Nth from start of the previous column, where N is your row number

---

<div class="post-metadata">

**Author:** ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)\
**Post date:** [December 18, 2024, 7:33pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677/3 "2024-12-18T19:33:17Z")

</div>

It didn’t work.  
Can you make an example, please.

---

<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:** [December 18, 2024, 8:06pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677/4 "2024-12-18T20:06:13Z")

</div>

Can you show where you got stuck?

---

<div class="post-metadata">

**Author:** ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)\
**Post date:** [December 19, 2024, 8:11pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677/5 "2024-12-19T20:11:28Z")

</div>

Good afternoon,  
What happened was that I had 4 items to use in the single value and I put the sequence from 0 to 3, however, the database had 20 rows and I discovered that if they didn’t number them from 0 to 19, I would get an error. I managed to resolve it.  
Thanks everyone.

---

<div class="post-metadata">

**Author:** ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)\
**Post date:** [December 19, 2024, 8:12pm UTC](https://community.glideapps.com/t/joined-list-to-column-for-colection/78677/6 "2024-12-19T20:12:59Z")

</div>

Dont need to use split text.