# Text Column to Array for making choice?

**URL:** <https://community.glideapps.com/t/text-column-to-array-for-making-choice/64886>\
**Category:** Ask for Help\
**Tags:** choice\
**Created:** [August 10, 2023, 4:16am UTC](https://community.glideapps.com/t/text-column-to-array-for-making-choice/64886 "2023-08-10T04:16:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin)\
**Post date:** [August 10, 2023, 4:16am UTC](https://community.glideapps.com/t/text-column-to-array-for-making-choice/64886/1 "2023-08-10T04:16:06Z")

</div>

I have a text column with “Red, Green, Brown, Yellow, Black”  
I want to represent each as an option using the choice components.

Example below:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0b2efda0a851d2a3f55a5404c2a5a4f2398bef2.png)  
E

---

<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:** [August 10, 2023, 4:21am UTC](https://community.glideapps.com/t/text-column-to-array-for-making-choice/64886/2 "2023-08-10T04:21:48Z")

</div>

You need to use the “Miracle Method”

> [@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:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 17, 2023, 4:22am UTC](https://community.glideapps.com/t/text-column-to-array-for-making-choice/64886/3 "2023-08-17T04:22:35Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.