xxxxxxxxxx
/**
* @customfunction
*/
function covid(range) {
let delimiter = ", ";
let newRows = [];
for (let i in range) {
let row = range[i];
let id = row[0];
let strings = row[1].split(delimiter); // split the responses
for (let j in strings) {
newRows.push([id, strings[j]]); // links the responder id to its splitted response
}
}
return newRows; // prints the rows
}