# Dropdown Choice Component From Multiple Rows

**URL:** <https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224>\
**Category:** Ask for Help\
**Tags:** choice, components\
**Created:** [January 15, 2025, 7:18pm UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224 "2025-01-15T19:18:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Felipe\_Andai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/felipe_andai/32/21970_2.png) [@Felipe\_Andai](https://community.glideapps.com/u/Felipe_Andai)\
**Post date:** [January 15, 2025, 7:18pm UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/1 "2025-01-15T19:18:14Z")

</div>

Hi. Another choice dropdown question. I know for sure that dropdown choice components must obtain their data from columns and single rows. Can I transpose those rows to form columns in a new “auxiliar table”, and if yes, how can I select just a few rows af that second table? If not, is there a way that glide can use an array to populate a choice component? Thanks in advance!

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [January 15, 2025, 9:49pm UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/2 "2025-01-15T21:49:28Z")

</div>

> [@Felipe\_Andai](#):
>
> Can I transpose those rows to form columns in a new “auxiliar table”, and if yes, how can I select just a few rows af that second table?

You want cells to become the columns name?

---

<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:** [January 15, 2025, 9:56pm UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/3 "2025-01-15T21:56:23Z")

</div>

> [@Felipe\_Andai](#):
>
> obtain their data from columns and single rows

You are mixing up the terms Rows and Columns,which may lead to confusion.

Rows are the horizontal arrangement of data, while columns are the vertical arrangement of data. Items that go from left to right are in a row, while items that go from top to bottom are in a column.

---

<div class="post-metadata">

**Author:** ![Felipe\_Andai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/felipe_andai/32/21970_2.png) [@Felipe\_Andai](https://community.glideapps.com/u/Felipe_Andai)\
**Post date:** [January 16, 2025, 12:04am UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/4 "2025-01-16T00:04:54Z")

</div>

I understand what rows and columns are. My question is: since Glide can only populate a choice component with data coming from a single column, and in my structure those data points are in rows, is it possible to transpose those rows into columns in order to use, for example, a dropdown menu?

---

<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:** [January 16, 2025, 12:39am UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/5 "2025-01-16T00:39:30Z")

</div>

> [@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:** ![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:** [January 16, 2025, 12:40am UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/6 "2025-01-16T00:40:17Z")

</div>

However, these days I tend to use the AI column more for this.

> [@Can this be done? Choose and Add](https://community.glideapps.com/t/can-this-be-done-choose-and-add/79223/3):
>
> You can try my setup here. Prompt this into your AI component as a first prompt. \<body x-data="state" class="" :class="{ 'cursor-pointer': hasBodyAction }" style="height: auto !important;" data-iframe-overflow=""\> \<div x-show="themeLoaded" class="@container w-full body-base antialiased" style=""\> \<div :class="{ 'px-4 py-1 sm:px-5 md:px-6 lg:px-7 xl:px-8': mode === 'standalone' }" class="px-4 py-1 sm:px-5 md:px-6 lg:px-7 xl:px-8"\> \<div class="w-full"\> \<label for="lic…

Here’s a prototype.

---

<div class="post-metadata">

**Author:** ![Felipe\_Andai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/felipe_andai/32/21970_2.png) [@Felipe\_Andai](https://community.glideapps.com/u/Felipe_Andai)\
**Post date:** [January 16, 2025, 12:43am UTC](https://community.glideapps.com/t/dropdown-choice-component-from-multiple-rows/79224/7 "2025-01-16T00:43:49Z")

</div>

I’ll give it a try. Thanks!