# Create a comma separated list from sometimes empty columns

**URL:** <https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849>\
**Category:** Ask for Help\
**Created:** [August 9, 2023, 11:34am UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849 "2023-08-09T11:34:48Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [August 9, 2023, 11:34am UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/1 "2023-08-09T11:34:48Z")

</div>

I think it is a simple question - maybe you can help me out.

I need to create a comma separated list (to be used in an url)  
Some of the values might be present - some might be empty

Example  
A\_1,B\_1,C1

Sometimes the value C1 is not present and therefore the result should be  
A\_1,B\_1

If the values are present all the time it would be easy to use a template column - but it might vary which values wound be there.

Other examples  
A\_1  
A\_1,C1

I thought I would be able to use array column or join list column - but cannot see a way through that.

Any thoughts on that?

---

<div class="post-metadata">

**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:** [August 9, 2023, 11:48am UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/2 "2023-08-09T11:48:24Z")

</div>

Use a Make Array column to first create an array, then use a Joined List column on the array column.

This should get the result you want.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [August 9, 2023, 11:58am UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/3 "2023-08-09T11:58:02Z")

</div>

@Darren_Murphy I thought I could do so - but the Joined List column isn’t available to choose for some reason.

Any suggestion what to do then?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5dea9a0124d153b43d735f317684821565a40780.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3a47d867c63624e181375253795e885343ae52a5.png)

---

<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:** [August 9, 2023, 12:08pm UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/4 "2023-08-09T12:08:20Z")

</div>

![Screenshot_20230809-070746](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3538b50e9b120dcf2777effd36dbd6a339e5b68.jpeg)

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [August 9, 2023, 12:14pm UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/5 "2023-08-09T12:14:08Z")

</div>

@Jeff_Hager Thx - I will make an appointment with the optician 🙂

---

<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:** [August 9, 2023, 12:52pm UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/6 "2023-08-09T12:52:05Z")

</div>

Hehe, that part can be easily missed sometimes.

---

<div class="post-metadata">

**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:** [August 16, 2023, 12:52pm UTC](https://community.glideapps.com/t/create-a-comma-separated-list-from-sometimes-empty-columns/64849/7 "2023-08-16T12:52:46Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.