Rollup or Lookup for all instances of past data?
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.
Example:
Week 1 should be first
24, 67, 45, 68, 599, 3358, etc. etc.
Any idea how to do this?
Alright, so I figured it out through an automation.
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?
