# Convert an array (from match multiple relation) into a single column

**URL:** <https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530>\
**Category:** Ask for Help\
**Created:** [September 29, 2020, 8:10pm UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530 "2020-09-29T20:10:06Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)\
**Post date:** [September 29, 2020, 8:10pm UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/1 "2020-09-29T20:10:06Z")

</div>

I’m joining two sheets with a match multiple relation and through a lookup I get the values into a new column, which then holds array values.

Unfortunately these array values can not be displayed in an inline list (e.g. in the details field).

Is there a way to convert this array into say a comma separated text field? Google sheet does not help as the lookup columns are not showing up in the sheet.

Thanks for your suggestions.

---

<div class="post-metadata">

**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:** [September 29, 2020, 9:05pm UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/2 "2020-09-29T21:05:44Z")

</div>

A Joined List column will do that for you.

---

<div class="post-metadata">

**Author:** ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)\
**Post date:** [September 30, 2020, 6:20am UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/3 "2020-09-30T06:20:35Z")

</div>

Jeff, thank you for your tip,

unfortunately, when I try to create a new column (Joined List), the columns with the array values which I created first through the Relation or Lookup, don’t show up in the dropdown where you select the “Join the texts in:”, although they are in the same table where I want to create the new column.

Is there some other magic needed?

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 30, 2020, 6:27am UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/4 "2020-09-30T06:27:24Z")

</div>

Are those single Relations? I mean, without **Match multiple** selected

---

<div class="post-metadata">

**Author:** ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)\
**Post date:** [September 30, 2020, 7:48am UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/5 "2020-09-30T07:48:14Z")

</div>

No, Single Relations work, I have a true 1: n relation, see also in my title 😉

---

<div class="post-metadata">

**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:** [September 30, 2020, 9:06am UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/6 "2020-09-30T09:06:51Z")

</div>

So you’re trying to join values in an array column?

---

<div class="post-metadata">

**Author:** ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)\
**Post date:** [September 30, 2020, 2:02pm UTC](https://community.glideapps.com/t/convert-an-array-from-match-multiple-relation-into-a-single-column/16530/7 "2020-09-30T14:02:04Z")

</div>

Thank you, now it works with the joined list column.  
Don’t know why it didn’t work in the first place.

I have 3 tables A, B, C and work with a m:1:n relation and obviously I mixed up some of the relations.  
Now I get the values from A into C as a comma separated text value