Ok, Here’s the scoop. I have a Google Form - response form that I want to take the input of 50 first names and 50 last names from the response form which is in one row and move it to a Master sheet where it will be split into two columns with the first name in one column and the email for that individual in the next row. I’ve tried having it set up as the Line-Item Properties with First Name (in order) and second Properties with Email. Didn’t work. I then created a Line-Item of Users with First Name | Email to redirect a Column on the Master Sheet where I have a User Column which the splits the first name into another column and the email into another column.
I also have tried looping all of this only to have the frustration of it all dumping into one row.
What am I doing wrong in Formatter???
Alyse