# Transpose an Array to another table **URL:** \ **Category:** Ask for Help\ **Created:** [March 21, 2025, 5:21am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884 "2025-03-21T05:21:43Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\ **Post date:** [March 21, 2025, 5:21am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/1 "2025-03-21T05:21:43Z")
Hello, I’m back again. I’ve done some digging in the forum, but I couldn’t find the way out yet. I need to transpose two arrays to another table, where the result I expect will be side-by-side, for my new lookup reference. Here is my table. ![Screenshot 2025-03-21 at 13.11.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c98af780b6250e52d71f80e94d1fd240d209f3d1.png) The result in the new table that I expect is just like: Array PUTS | Split\_NPK 138 | 15 36 | 10 30 | 12 What is the efficient way to do that? Additional information: I’ve tried the method of making RowIndex form RowIDs combined with Single Value, but it’s still not showing what I expected. ![Screenshot 2025-03-21 at 14.05.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/0503ff3a80abea7a0aaa1a4bf8aa1e03a5106154.jpeg) ---
**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:** [March 21, 2025, 6:45am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/2 "2025-03-21T06:45:15Z")
It’s not working because you’re not targeting the array correctly. Rather than targeting it via the original table, you should target it directly from the same row. Your single value column should look something like the below: ![CleanShot 2025-03-21 at 14.44.34@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c1525686010fbe5ac05eab23f8d646b98895d4d5.jpeg) ---
**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:** [March 21, 2025, 7:03am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/3 "2025-03-21T07:03:49Z")
oh, something else that I just noticed… you are missing a column. You need a column that applies the array from the other table to every row, and then you need to target that column with the single value column. How you get the array into the table depends on your specific setup. There are several ways to do it. It could be through a relation and a lookup, or it could be set into a user specific column (either in the helper table or the user profile row) as a navigation action. ---
**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\ **Post date:** [March 22, 2025, 1:52am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/4 "2025-03-22T01:52:51Z")
Back again, Darren, with a good news; after several trial and error. 😅 Thanks for the enlightenment once again. Here is what I did: ![Screenshot 2025-03-22 at 09.38.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/850a0dcadeeec21ddf63d39db2ef2e471ddaa757.jpeg) I wonder why I have to Join then Split again to do the transpose with the Single Value. But I’m okay with that as long as my aim is achieved. 🫶 ---
**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:** [March 22, 2025, 8:31am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/5 "2025-03-22T08:31:44Z")
I’m confused. Why do you need to do the make a join list - split the joined list part? ---
**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\ **Post date:** [March 24, 2025, 11:49pm UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/6 "2025-03-24T23:49:07Z")
Dear Experts, Apologize for not replying quickly. I remembered when last time I transposed directly (not doing join then split), the result was not as I expected. The result showed many values in each row, so I did that trial and error, using join-split then transpose with Single Value. Until today I tried again change the target column directly to the first column; this time that’s just work 😅 So I just erased those join-split tables, to be like this: ![Screenshot 2025-03-25 at 06.38.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4c1f6d5ea374ed7b0d407fb8f09faae1334c33b9.png) That’s all the columns. So I created my _dynamic reference_ column for a calculation in another table. Pardon me for confusing you, but I’m pretty sure the result in previous day showed many values in a row. But today it doesn’t. ---
**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\ **Post date:** [March 25, 2025, 12:00am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/7 "2025-03-25T00:00:56Z")
What is the difference of my first post of thie thread, with this one. Because with same settings, it returned different result then VS now. ![Screenshot 2025-03-25 at 07.02.51](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a8ec2f53412229cda2938cd7631ca2d6f025d08.png) I will bring here the picture from my first post. ![Screenshot 2025-03-25 at 06.58.37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff2e5ce1a0be0e7f4f778fcbce3540838162d968.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:** [March 25, 2025, 12:58am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/8 "2025-03-25T00:58:55Z")
> [@Darren\_Murphy](#): > > How you get the array into the table depends on your specific setup. There are several ways to do it. It could be through a relation and a lookup, or it could be set into a user specific column (either in the helper table or the user profile row) as a navigation action. It relates to this part. The ultimate aim is to get the array of values into the helper table. As long as you can bring that array into every row, then you can set it up the way Darren suggested. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 1, 2025, 12:59am UTC](https://community.glideapps.com/t/transpose-an-array-to-another-table/80884/9 "2025-04-01T00:59:54Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.