# Merge info from 2 columns in Glide **URL:** \ **Category:** Ask for Help\ **Created:** [March 10, 2021, 2:52am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044 "2021-03-10T02:52:25Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![RonnieL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronniel/32/980_2.png) [@RonnieL](https://community.glideapps.com/u/RonnieL)\ **Post date:** [March 10, 2021, 2:52am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044/1 "2021-03-10T02:52:25Z")
Hi, Quick question - what’s the best way to merge info that exists in 2 separate columns in Glide? Column 1 is actually an array column in Glide that contains email addresses (all addresses live in Google Sheet in similar columns and thus appear as an array column) Column 2 is a lookup type column in Glide that retrieves additional email addresses from another table. I want to combine all these email addresses into a 3rd column and set it as row owner. Any advice? Thanks, Ronnie ---
**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:** [March 10, 2021, 3:09am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044/2 "2021-03-10T03:09:43Z")
This is not possible at the moment. Row owners can’t be computed columns (lookup within Glide)—you’d have to do this lookup within Google Sheets and add it to your array column. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 10, 2021, 3:10am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044/3 "2021-03-10T03:10:38Z")
In some situations, I don’t think it’s possible to join arrays to arrays, but I think you could do it if you first create a Joined List column with a comma delimiter to replace the Lookup column, then create a Template column to join your individual sheet columns into a comma delimited list, along with the Joined List column. That should give you a comma delimited list if all emails combined. Finally you can create a Split Text column to turn that template column back into an array. Edit: Missed the part about wanting to use this for row owners. Definitely not possible for that use case. > [@🛡️Roles and Row Owners DEMYSTIFIED](https://community.glideapps.com/t/roles-and-row-owners-demystified/22956/9): > > Great information. I also will be referring people to this post…probably often. I just want to add the reason WHY row owners can only be applied to basic columns in a google sheet or glide table. I think what many people don’t realize is that any computed columns are actually computed on a user’s device. It may seem like it’s done on the glide server, but it’s not. This includes relations, lookups, template, math, etc. Anything that’s not a basic column. Because of that, for example, the … ---
**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:** [March 10, 2021, 3:13am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044/4 "2021-03-10T03:13:21Z")
> [@Jeff\_Hager](#): > > Finally you can create a Split Text column to turn that template column back into an array. Still can’t use this for row owners though… ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 10, 2021, 3:15am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044/5 "2021-03-10T03:15:15Z")
@Robert_Petitto missed that part of the original question. Updated my post. ---
**Author:** ![RonnieL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronniel/32/980_2.png) [@RonnieL](https://community.glideapps.com/u/RonnieL)\ **Post date:** [March 10, 2021, 3:43am UTC](https://community.glideapps.com/t/merge-info-from-2-columns-in-glide/24044/6 "2021-03-10T03:43:48Z")
Thanks for the info! Saved me hours of going in circles. I think I’ll try to solve it via the Google sheet then because the end goal is to create a row owner column.