# Array column using data editor columns **URL:** \ **Category:** Ask for Help\ **Created:** [September 3, 2020, 7:41pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229 "2020-09-03T19:41:33Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Yuval](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yuval/32/4199_2.png) [@Yuval](https://community.glideapps.com/u/Yuval)\ **Post date:** [September 3, 2020, 7:41pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/1 "2020-09-03T19:41:33Z")
I have a sequence of columns in the google sheet that form an array column in my data editor. Is there a way to create the sequence of columns in the data editor directly and have an array column formed out of them? (for performance purposes I prefer the editor directly) Thanks ---
**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:** [September 3, 2020, 7:57pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/2 "2020-09-03T19:57:39Z")
You bet. As long as they are of the same column type and are next to each other sequentially, it should work. ---
**Author:** ![Yuval](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yuval/32/4199_2.png) [@Yuval](https://community.glideapps.com/u/Yuval)\ **Post date:** [September 3, 2020, 8:00pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/3 "2020-09-03T20:00:59Z")
Thanks, any idea why these two don’t become an array? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/47e943c03a35e8dde6696e38eea241543577a1ab.png) ---
**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:** [September 3, 2020, 8:22pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/4 "2020-09-03T20:22:20Z")
Because they’re GlideColumns and not basic columns. ---
**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 3, 2020, 9:19pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/5 "2020-09-03T21:19:20Z")
Yeah glide columns can’t become an array based on sequentially numbering them. Only columns that exist in the sheet. I wish you could, but it’s not an option. What you could do is create a template column that joins all the lookup columns with a comma (or any other) delimiter. Then use the split texts column to split that template column into an array. Also gonna throw a request in here that I really wish we could access the individual array items in a Split Texts column, like we can with a sheet array. It would be an awesome way to split a formatted date column to get separate date and time values to use in separate components. ---
**Author:** ![Yuval](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yuval/32/4199_2.png) [@Yuval](https://community.glideapps.com/u/Yuval)\ **Post date:** [September 3, 2020, 9:29pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/6 "2020-09-03T21:29:58Z")
Thanks so much! ---
**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:** [September 3, 2020, 11:27pm UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/7 "2020-09-03T23:27:56Z")
Split date to columns would be brilliant! How would you name the columns, though? Would it just be whatever the column name is 1,2 and 3? ---
**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 4, 2020, 12:11am UTC](https://community.glideapps.com/t/array-column-using-data-editor-columns/15229/8 "2020-09-04T00:11:56Z")
I’m not sure. I’ve thought about that, but I’m sure the dynamic length of the array could make it pretty complicated. So if you have 3 array items and you are trying use ‘SplitArray 5’ in a component, then I suppose you would just get a blank as a result, but I don’t know how you would pick a specific array position from a dynamic length array. It’s not like Glide could provide us with an infinite list of array items, or even 100 or 1000, when trying to select an individual array item for a text component. This makes most sense when each array item position is predetermined, which probably wasn’t the original intention of Split Texts, but like in my case, it would be awesome for splitting date and time into separate values that can be placed in separate components. Right now you’d have to use a sheet formula to duplicate the date so you can format it separately in Glide (one as date only and one as time only). Really any CSV style value in a cell that comes from a template or user input, were the positions are predetermined. I’m sure there could be a lot of specific use cases. But, yeah, I’m not sure what would be the best way for Glide to present that option to us. Maybe let us select a Split Texts column for a single value component, but also prompt us for an array position as well???