For every new Google Spreadsheet row we have a cell with coma separated values, which could contain the first name, last name and email of 1 or more individuals:
row 1, cell 1: john,example,email@example.com,bob,example2,firstname.lastname@example.org,alice,example3,email@example.com
We are trying to generate new Rows in a new Spreadsheet where we can populate 3 columns with this data, First Name, Last Name, Email Address.
We manage to use the Formatter with Text to Line Items and we get:
But from here we cannot seem to map these to new individual rows in Google Sheets, we need help.
Best answer by Andrei O.View original