# Opposite action of "single value"

**URL:** https://community.glideapps.com/t/opposite-action-of-single-value/67201
**Category:** Ask for Help
**Created:** [October 23, 2023, 8:11am UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201 "2023-10-23T08:11:00Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![EPS\_Simonin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eps_simonin/32/62668_2.png) [@EPS\_Simonin](https://community.glideapps.com/u/EPS_Simonin)
#### Post date: [October 23, 2023, 8:11am UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/1 "2023-10-23T08:11:00Z")

</div>

Hi,  
i want to know how to do the opposite action of single value in a table.  
Single value choose a number (first, second…) of a column and copy it on every line of the single value column.  
Is it possible to do to opposite action. From first line of some columns you created to a new column where every line is a different column you chose.

 ![Single value](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d13f49dc85574013d6ecd33446a9b7d79cf0f1d7.png)

Thanks for your help

---

<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: [October 23, 2023, 8:43am UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/2 "2023-10-23T08:43:46Z")

</div>

See below:

> [@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: ![EPS\_Simonin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eps_simonin/32/62668_2.png) [@EPS\_Simonin](https://community.glideapps.com/u/EPS_Simonin)
#### Post date: [November 21, 2023, 12:39pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/3 "2023-11-21T12:39:05Z")

</div>

hi  
i didn’t succeed to do it.  
is it possible for you to shar me an app to show me how you proceed and get datas from several columns organized in lines of the same column ?  
Pierre

---

<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: [November 21, 2023, 1:09pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/4 "2023-11-21T13:09:36Z")

</div>

Give me two screen shots:

- what your data looks like now
- what you want the end result to look like

And then I’ll guide you how to get there.

---

<div class="post-metadata">

### Author: ![EPS\_Simonin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eps_simonin/32/62668_2.png) [@EPS\_Simonin](https://community.glideapps.com/u/EPS_Simonin)
#### Post date: [November 27, 2023, 3:07pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/5 "2023-11-27T15:07:08Z")

</div>

![test](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e7841d7437055907dd3baac4f780588e2e846c0.png)  
Hi  
thanks for your help  
As i show you in screenshot  
i want datas frome several columns to go in each line of the same column. The opposite action of single value.

---

<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: [November 27, 2023, 3:09pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/6 "2023-11-27T15:09:29Z")

</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: ![EPS\_Simonin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eps_simonin/32/62668_2.png) [@EPS\_Simonin](https://community.glideapps.com/u/EPS_Simonin)
#### Post date: [November 27, 2023, 3:22pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/7 "2023-11-27T15:22:50Z")

</div>

Yes. But i didnt succed with numbers.  
I ll try another Time.  
I hoped you could show me in an app you share.  
Thanks for helping.

---

<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: [November 27, 2023, 3:52pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/8 "2023-11-27T15:52:48Z")

</div>

Use a Make Array column to create an array of all the values, then follow the steps in Bobs video.

---

<div class="post-metadata">

### Author: ![EPS\_Simonin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eps_simonin/32/62668_2.png) [@EPS\_Simonin](https://community.glideapps.com/u/EPS_Simonin)
#### Post date: [November 27, 2023, 4:35pm UTC](https://community.glideapps.com/t/opposite-action-of-single-value/67201/9 "2023-11-27T16:35:02Z")

</div>

Ok thanks !
