Help

Re: Rollup or Lookup for all instances of past data?

288 0
cancel
Showing results for 
Search instead for 
Did you mean: 
james_turner
4 - Data Explorer
4 - Data Explorer

Hey everyone!

I’m trying to pull the data from each of these columns into another table. I need them to be transferred as they are currently sorted and separated by a comma.

image

Example:

Week 1 should be first

24, 67, 45, 68, 599, 3358, etc. etc.

Any idea how to do this?

1 Reply 1
james_turner
4 - Data Explorer
4 - Data Explorer

Alright, so I figured it out through an automation.

image

BUTTTT, now the issue I’m having is the program I’m trying to run this through is reading every single character as a separate item in an array - that’s causing me some serious issues (especially when we get into the big 4-5 digit numbers in the list)

Sooo, I think a workaround would be to parse every number separated by a comma and a space into a “single select” column, but I can’t figure out the automation to make this happen.

Any ideas?