Skip to main content

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?


Reply