# How to transpose data **URL:** \ **Category:** Ask for Help\ **Created:** [December 10, 2020, 8:52pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683 "2020-12-10T20:52:04Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [December 10, 2020, 8:52pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/1 "2020-12-10T20:52:04Z")
Maybe some of you can me out here. I have data in one structure but would like it in another structure that would help me use the data for an inline list. The inline list should be put on the different companies - and contain the information relevant for the company - like Telephone, Email etc. **Data source** _Company Telephone Email_ a1 123456 1@email.dk b2 234567 2@email.dk **Transformed data:** _Company Datatype Datavalue_ a1 Telephone 123456 a1 Email 1@email.dk b1 Telephone 234567 b1 Email 2@email.dk The inline list should look like what is shown on the app in this post: > [@Tiles with links!](https://community.glideapps.com/t/tiles-with-links/8109): > > Wow It is possible to open links from tiles - and that is great !! Inspired by the post by @Robert_Petitto [Hey! List Action \> Open Link Available!](https://community.glideapps.com/t/hey-list-action-open-link-available/8065) I created a little app to exploit this possibility. The app is copyable. The used icons are from [https://www.flaticon.com/](https://www.flaticon.com/) If you want to use them then please check out the terms. I have made an inline list with horizontal scrolling with different types of links: facebook, email, instagram, location, sms, phone… Platform ind… ---
**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:** [December 11, 2020, 2:13am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/2 "2020-12-11T02:13:49Z")
Apologies for the long formula but I wanna cover the empty cases as well. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbe53e8dfb9d2e1bc56b09f736c4b2635ca6da79.png) > **[Thinh Dinh's lab V2.0](https://docs.google.com/spreadsheets/d/1JzBrp4R1zK9CMfmTzWWcPPep9-ZCl3OXxgWu27NWCy8/edit#gid=1439341631)** > > Lowest Header > > Column A,Column B,Column C,Column D,Column E,Column F,Column G,Column H,Lowest value,Lowest value column > 5,7,9,1,6,4,2,6,1,Column D > \-5,-4,-6,-99,88,77,33,22,-99 > 14,7,18,7,15,13,7,3,3 ---
**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:** [December 11, 2020, 2:15am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/3 "2020-12-11T02:15:28Z")
Not sure if it helps but you can have a look here as well. > [@Dynamically access social links in Glide - using new actions](https://community.glideapps.com/t/dynamically-access-social-links-in-glide-using-new-actions/19089): > > Probably you have wanted to build a dynamic list of social links: Email, Facebook, Twitter, LinkedIn, etc. before but there’s no straightforward way to do it without costing rows. Now with the actions Glide introduced, I achieved the thing above just this week with 4 rows, and think this can be helpful for people so I would share this. [[Dynamically access social links in Glide - using new actions] ](https://www.youtube.com/watch?v=eT9eSZq0xK8) First time using Screenity to record + write on screen at the same time, hopefully i… ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [December 16, 2020, 8:28pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/4 "2020-12-16T20:28:09Z")
@ThinhDinh thanks a lot for not only providing an answer to the question but also suggesting another solution to the problem at hand 👍 I actually did go with the other suggestion to use dynamically link. The concept is pretty hard to grasp - and when I first read the Post before my own post I couldn’t see a need for it. But it is really clever I must say. I personally would rather have 3 items in a list which are all links instead of 4 items where one item when clicked just tells that the user doesn’t have an email. I just made a visibility condition to filter out items that do not have a dynamically link. One major drawback with the dynamically link approach was that I had to do the compound action 6 times as detailed screen I was using was “called” from different lists. Cannot wait till mid January where it should be possible to reuse actions. The inline list with the dynamic links turned out to look like this ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/167c740615bbe679252c4a5174f17067bcf50ee0.jpeg) ---
**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:** [December 17, 2020, 12:19am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/5 "2020-12-17T00:19:11Z")
That looks pretty nice! Hopefully we can have a better way to do this very soon. ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [April 8, 2021, 5:34am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/6 "2021-04-08T05:34:38Z")
You suggested that we might have a better way to do this soon. Is there a way to do this easily now or are the suggestions you provided the only way to transpose data from columns to rows? What is the Whole-Row relation you have in the video tutorial? Can you share how it is setup and using which columns in which sheets? ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [April 8, 2021, 6:00am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/7 "2021-04-08T06:00:35Z")
@Food2Soil the idea is the the post by thinh > [@Dynamically access social links in Glide - using new actions](https://community.glideapps.com/t/dynamically-access-social-links-in-glide-using-new-actions/19089): > > Probably you have wanted to build a dynamic list of social links: Email, Facebook, Twitter, LinkedIn, etc. before but there’s no straightforward way to do it without costing rows. Now with the actions Glide introduced, I achieved the thing above just this week with 4 rows, and think this can be helpful for people so I would share this. [[Dynamically access social links in Glide - using new actions] ](https://www.youtube.com/watch?v=eT9eSZq0xK8) First time using Screenity to record + write on screen at the same time, hopefully i… ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [April 8, 2021, 3:57pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/8 "2021-04-08T15:57:40Z")
@ThinhDinh You suggested that we might have a better way to do this soon. Is there a way to do this easily now or are the suggestions you provided the only way to transpose data from columns to rows? What is the Whole-Row relation you have in the video tutorial? Can you share how it is setup and using which columns in which sheets? The other issue I’m having is that when I try to set columns the only option it offers is This Row. I see you have the option to select Rel 1, Rel 2, Rel 3 as your rows. I’m not able to understand what I’m doing wrong. ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [April 8, 2021, 3:59pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/9 "2021-04-08T15:59:06Z")
Thankyou. I saw the post and video by thinh. my question was related to the whole\_row relation he has set up in his video. Thankyou for your response. ---
**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:** [April 8, 2021, 11:54pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/10 "2021-04-08T23:54:59Z")
> [@Food2Soil](#): > > You suggested that we might have a better way to do this soon. Is there a way to do this easily now or are the suggestions you provided the only way to transpose data from columns to rows? There’s still no way to do this easily solely in Glide now. For this specific type of request I usually have 2 options: - If it’s only the signed-in user viewing that data, I use an if then else column to transpose it. Let’s say you want to transpose Data A and Data B (different columns in the user profiles sheet) to 2 rows, I would create a new Glide Table with 2 rows named Data A and Data B, then an If Then Else column: If Row Name is Data A then Signed-in User’s Data A, if Row Name is Data B then Signed-in User’s Data B. - If anyone can view those then I use the set column approach above. > [@Food2Soil](#): > > What is the Whole-Row relation you have in the video tutorial? Can you share how it is setup and using which columns in which sheets? It is a single value column pointing to an entire row that can act as a pathway to that row, the same way as a relation. Let me know if you need more help with this. ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [April 9, 2021, 5:18pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/11 "2021-04-09T17:18:06Z")
Thankyou. I ended up using the first option. Am not at the level where I can wrap my head around that dynamic link solution. But it is very cool. Thanks so much. I really appreciate you walking me through the steps. ---
**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:** [April 9, 2021, 11:33pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/12 "2021-04-09T23:33:31Z")
I also want to say sorry I cleared that app off the dashboard a while ago so the example isn’t available anymore. If you really need that I will re-build it in my free time. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [April 10, 2021, 4:42am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/13 "2021-04-10T04:42:29Z")
@ThinhDinh @Food2Soil i have used the dynamic link idea in the Business directory app which is in the template store so Thinh make take the time off 😜 ---
**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:** [April 10, 2021, 8:16am UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/14 "2021-04-10T08:16:09Z")
Great to hear hehe. Here’s the link for anyone interested. > **[Free Business directory app • Glide](https://www.glideapps.com/templates/business-directory-2w)** > > The app provides a backbone for creating your our business directory. It has an onboarding flow and gives the user control of how he wants to access external ressources like instagram, facebook, phone etc - and whether to open in a website or... ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/how-to-transpose-data/19683/15 "2024-01-17T16:52:39Z")