Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. /*
  2. Summary of the Multiple Choices selected, with a blank space between each
  3. */
  4. =ARRAYFORMULA( // Iterate over the rows (defined in parameters)
  5. if(row(Data!A1:A)=1, // If the first row...
  6. "Concat", // ... just print the column name
  7. REGEXREPLACE( // Every other line...
  8. Data!F1:F&" | "&Data!G1:G&" | "&Data!H1:H&" | "&Data!I1:I, // ... concat each row with a space-bar " | "
  9. "^[| ]+|[| ]+$", "" // ... and remove the unnecessary start and end space-bars
  10. ) // ... with a cool regular expression
  11. )
  12. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement