I’m working within Google Sheets and passing information from multiple sheets to another. However, when the user inputs their Reps and Weight into a form (That then sends the information to Google Sheets), it places ALL of that info within a single cell.
So, cell “C2” will receive:
“Reps: 15, Weight: 150
Reps: 12, Weight: 175
Reps: 10, Weight: 200
Reps: 8, Weight: 225
Reps: 6, Weight: 250”
In the form of one single cell.
Using App Script, how can I dissect this single cell to have access to the numbers so I can place each one into a different corresponding cell?
I want to be able to move 15 to “C4” and 150 to “C5” and so on. I don’t need any of the words etc, just the numbers saved into separate variables.