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