# 🐟🥖🧺 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:** 14\ **Page:** 2
**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 6, 2023, 3:06am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/21 "2023-12-06T03:06:14Z")
Ya…no good way to clear entire column. Been asking for this feature for years. Please vote: > [@Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584): > > Currently, the Action to “Set columns” only consider the current sheet or any single relations (to update a column in a single row). I’m trying to create a “bulk approval” process where the “set column” action could look at a multiple relation and update each corresponding row in that relation. ---
**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, 3:14am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/22 "2023-12-06T03:14:24Z")
Is anybody in Glide, even looking at these votes? ---
**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, 3:17am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/23 "2023-12-06T03:17:18Z")
ok voted 😟 ---
**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 6, 2023, 3:29am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/24 "2023-12-06T03:29:14Z")
> [@biha](#): > > But how to clear entire column after submitting the answer? Use the API. ---
**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 6, 2023, 3:44am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/25 "2023-12-06T03:44:12Z")
> [@Darren\_Murphy](#): > > Use the API. This is the only way to this if your data lives in Glide Tables. However, majority of users are no coders. We need a native, no code solution for the 80%. ---
**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, 3:48am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/26 "2023-12-06T03:48:57Z")
It is not the only way… 😉 ---
**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, 5:02am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/27 "2023-12-06T05:02:02Z")
How @Uzo ? ---
**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, 5:03am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/28 "2023-12-06T05:03:23Z")
How to use API? ---
**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 6, 2023, 5:04am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/29 "2023-12-06T05:04:23Z")
---
**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, 5:18am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/30 "2023-12-06T05:18:13Z")
My gosh, mine was only PRO, call API is for business so sad. ---
**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, 5:19am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/31 "2023-12-06T05:19:53Z")
😉 Visit my website… ---
**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 6, 2023, 5:20am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/32 "2023-12-06T05:20:31Z")
You can do the same thing with a webhook to Make. ---
**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, 5:26am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/33 "2023-12-06T05:26:56Z")
Another thing is my column is user-specific to be cleared. it is possible? I think no API for that column ---
**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 6, 2023, 5:39am UTC](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766/34 "2023-12-06T05:39:51Z")
No, you can’t change user specific columns via the API. In that case, you need to use the multi-row reset trick. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… [Previous page](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766.md?page=1)