# Column with Comma Separated Values

**URL:** <https://community.glideapps.com/t/column-with-comma-separated-values/9143>\
**Category:** Ask for Help\
**Created:** [May 14, 2020, 3:43pm UTC](https://community.glideapps.com/t/column-with-comma-separated-values/9143 "2020-05-14T15:43:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike\_Sammartano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_sammartano/32/3888_2.png) [@Mike\_Sammartano](https://community.glideapps.com/u/Mike_Sammartano)\
**Post date:** [May 14, 2020, 3:43pm UTC](https://community.glideapps.com/t/column-with-comma-separated-values/9143/1 "2020-05-14T15:43:40Z")

</div>

Hi everyone - I’m having what is probably a very simple to solve problem. I have a column in a sheet where come rows contain single values and others contain comma-seperated lists of values (the sheet is populated by a Google Form and this column stores the responses from a checkbox multi-select question). In my app, I would like the relation to sort rows out for all values within the comma-separated lists. The category in question is called “discipline” - I am attaching a link to the app and the sheet - any help would be greatly appreciated!

[Link to App](https://mamk-resources.glideapp.io/)  
[Link to Sheet](https://docs.google.com/spreadsheets/d/1KiwNKPgCSs_bGy8einQKGW8C-hmsxLDZlFNBlN0PAZg/edit?usp=sharing)

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [May 14, 2020, 4:57pm UTC](https://community.glideapps.com/t/column-with-comma-separated-values/9143/2 "2020-05-14T16:57:43Z")

</div>

Hey Mike,  
You can create separate columns for each ‘discipline’.  
Call them Discipline 1, Discipline 2, …

You can then use REGEXMATCH(), or simply us FIND() with Error Handling, for these columns to have these values.

---

<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:** [May 15, 2020, 12:09am UTC](https://community.glideapps.com/t/column-with-comma-separated-values/9143/3 "2020-05-15T00:09:04Z")

</div>

What would your final outcome in the sheet look like? Would a SPLIT work? I am open to help.

---

<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:** [May 15, 2020, 12:42am UTC](https://community.glideapps.com/t/column-with-comma-separated-values/9143/4 "2020-05-15T00:42:09Z")

</div>

I second the SPLIT idea if you will know the maximum number of Disciplines that would ever be selected. This could be written to a series of columns in the sheet using formulas. I would name for columns (Discipline 1, Discipline 2, etc.) which will give you an array column of ‘Discipline’.