# Need data from split to be used in choice

**URL:** <https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316>\
**Category:** Ask for Help\
**Created:** [April 13, 2025, 7:47am UTC](https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316 "2025-04-13T07:47:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\
**Post date:** [April 13, 2025, 7:47am UTC](https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316/1 "2025-04-13T07:47:46Z")

</div>

Hi all,I got data from multiple choice and record in a cell called “machine”, e.g., “mc01,mc02,mc03”. And I tried to use split to separate these data for use with choice. But It doesn’t work out.  
How can I separate these data and display in choice component?

---

<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:** [April 13, 2025, 7:52am UTC](https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316/2 "2025-04-13T07:52:38Z")

</div>

You need to transpose the array into a list with a helper table.

> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)

---

<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:** [April 13, 2025, 1:19pm UTC](https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316/3 "2025-04-13T13:19:49Z")

</div>

Do those machine IDs already exist in another table? If so you can use the Split column to create a Relation to the machine table. Then source your choice component from the relation.

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [April 14, 2025, 12:12am UTC](https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316/4 "2025-04-14T00:12:56Z")

</div>

If you don’t have those machine IDs already in another table, then you can use AI component to create a custom choice component.

---

<div class="post-metadata">

**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\
**Post date:** [April 16, 2025, 4:09am UTC](https://community.glideapps.com/t/need-data-from-split-to-be-used-in-choice/81316/5 "2025-04-16T04:09:20Z")

</div>

Thank you. I will try.