# šŸŸšŸ„–šŸ§ŗ Transpose Columns to an Inline List: The Miracle Method **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [October 7, 2021, 3:02pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766 "2021-10-07T15:02:01Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 7, 2021, 3:02pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/1 "2021-10-07T15:02:02Z")
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. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/9724c9956e154eb147c531cf85529ae268f45e31.jpeg "Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD") ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) ---
**Author:** ![Kyan\_Lynch](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyan_lynch/32/28521_2.png) [@Kyan\_Lynch](https://community.glideapps.com/u/Kyan_Lynch)\ **Post date:** [October 7, 2021, 3:22pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/2 "2021-10-07T15:22:33Z")
The template column as ā€œcurrent userā€ is genius and opens A LOT of doors for me. Thank you! ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [October 7, 2021, 5:59pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/3 "2021-10-07T17:59:28Z")
Good tutorial! Unfortunately, if it needs more items - you need to do all additional setup with the developer in columns. (I mean, it cannot be left to users to maintain it themselves) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 7, 2021, 6:01pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/4 "2021-10-07T18:01:35Z")
This is trueā€¦theyā€™d have to create a new ITE column for each item and append that template column in Glideā€¦ Thereā€™s probably a way to use spreadsheet formulas instead, but I was trying to do it all in Glide. ---
**Author:** ![Dcuras](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dcuras/32/32393_2.png) [@Dcuras](https://community.glideapps.com/u/Dcuras)\ **Post date:** [October 7, 2021, 8:50pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/5 "2021-10-07T20:50:55Z")
Totally agree. It has become one the staple tactics I implement into any new app. Props to @Robert_Petitto! ---
**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\ **Post date:** [October 7, 2021, 9:56pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/6 "2021-10-07T21:56:18Z")
brilliant! ---
**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:** [October 7, 2021, 11:00pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/7 "2021-10-07T23:00:22Z")
Not sure if this is better, but if you have to set up columns for new items, wouldnā€™t it cost less columns to achieve this by the following method? Iā€™m only using a screenshot of the table from your video to get the badges name for my example. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5ec922e26fe4d2021fb1956b91689493207bf196.jpeg) Use an If Then Else column, if Badges is Non-Smoker then you return the userā€™s Non-Smoker boolean, you continue that until Hydrates Regularly. Then you can still do an inline list and filter that by is true/is not true. Would it work? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 7, 2021, 11:30pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/8 "2021-10-07T23:30:21Z")
Hmā€¦thatā€™s a great idea too! Probably less intensive for sure. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [October 8, 2021, 12:13am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/9 "2021-10-08T00:13:04Z")
We donā€™t need that long transpose formula anymore. Miracle job @Robert_Petitto ---
**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\ **Post date:** [December 31, 2021, 2:57pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/10 "2021-12-31T14:57:48Z")
Awesome! I just needed to **transpose an array** and used an alternative method: - the new slice array plugin: [Slice Array column ā€¢ Glide (glideapps.com)](https://www.glideapps.com/plugins/slice-array) - with two helper columns for the slice function: start | end 0 | 1 1 | 2 2 | 3 ā€¦ | ā€¦ - and a ā€œjoined list columnā€ of that sliced array elements to have one element **as text** per row. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 31, 2021, 3:07pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/11 "2021-12-31T15:07:43Z")
Care to share an example? ---
**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:** [December 31, 2021, 3:18pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/12 "2021-12-31T15:18:06Z")
I also had a use case for a variation of this method just today. I needed to dynamically generate a list for a choice component that included the month names for each of the previous six months. - Started with a series of 6 math columns to determine the 1st day of each of the previous 6 months - Then a template column to join those together into a comma separated list - A split text column to turn that into an array - And finally the single value trick, using N from start This is a really useful method, and Iā€™ve found lots of use cases šŸ‘ ---
**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\ **Post date:** [December 31, 2021, 3:26pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/13 "2021-12-31T15:26:14Z")
Sure! In my use case I have teams with email addresses in an array of User1, User2, User3,ā€¦ (and row owners). I wanted to filter another sheetā€™s list (which user added what data?) though a choice component fed by the transposed user array (screen variable). And I even could make an ā€œall userā€ choice with the values of ā€œstart:0"and end:Number of last userā€ in the helper columns. ---
**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\ **Post date:** [January 17, 2022, 6:58pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/14 "2022-01-17T18:58:32Z")
Perfect method, also to solve the problem of feeding a choice from an array ā€¦ with some modifications, but the concept is always the same: I use an additional ā€œall purposeā€ table as if it were an array. It was particularly useful for managing product sizes and colors. ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [March 13, 2022, 5:36am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/15 "2022-03-13T05:36:43Z")
This is pure gold! Fantastic job! ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [November 2, 2022, 10:40am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/16 "2022-11-02T10:40:07Z")
Hi, basic question, but in DataEditor, could we use an excel formula ā€œTransposeā€? (even if I donā€™t manage to do it šŸ™‚ ) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 2, 2022, 11:06am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/17 "2022-11-02T11:06:45Z")
Unfortunately no, Glide doesnā€™t know how to handle that formula. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [July 11, 2023, 2:35pm UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/18 "2023-07-11T14:35:28Z")
Hi @Robert_Petitto, thank you again. Another question: can we do it the other way round? My use case: **Sheet 1** : Dozens of questions in 1 column + answers in 1 user specific column. I want to transpose answers then ā€œadd rowā€ into Sheet 2 (below). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55be9aae7771fec557edb0761cfcfa5a3407d2a5.png) **Sheet 2** : The same questions but positioned by column (like if it was a questionnaire in a form). I try this approach because I have many calculations to do **per question**. If I directly collect answers in Sheet 2 (by column), I have to duplicate these calculations for each column. While with the Sheet 1 approach, I can have only 1 column per calculation for all questions. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b073bc9cc77ab842d4b62c99a09e2c910fc17e9.png) Thank you! ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 6, 2023, 2:15am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/19 "2023-12-06T02:15:36Z")
Hi, Iā€™m trying to apply this method. But how to clear entire column after submitting the answer? Thank you!!! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 6, 2023, 2:44am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/20 "2023-12-06T02:44:00Z")
You can use some tricks for thatā€¦ but doing that in a Glide tableā€¦ not possible yet. > [@arrows\_counterclockwise Bulk clear, edit, restore and delete columns plus Undo action](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546): > > A little fun with Glide columns, using Java wink It works well and fast. You can edit or clear the whole column in one clickā€¦ then undo, edit, or restore all to default. I used a regular inline list. You can still edit, add or delete individual rows as usual. It is a free app with no scripts and no Google Sheetsā€¦ Pure Glide Page (App) [Next page](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766.md?page=2)