The data looks like following:
Name: Leo, Dylan
Age: 20, 21
Country: Canada, France
I would like to split them by comma and add two rows into google sheet:
Leo 20 Canada
Dylan 21 France
It should also work when I have n set data separated by comma and add n rows to google sheet.
How should I make it happen? Thanks.
Best answer by AndrewJDavison_LuhhuView original