in a google apps script, I try to tranform data spread in a column into an array. I would like to know if there is any better way to code this, maybe without using a loop ?
function myFunction3() {
var dataInCol = [['A'], ['B'], ['C'], ['D'], ['E'], ['F'], ['G']] ;
var dataInRow = [] ;
var i = 0 ;
while ( i < dataInCol.length ) {
dataInRow.push( dataInCol[i][0] ) ;
i++ ;
}
// logger returns : ' [A, B, C, D, E, F, G] '
Logger.log( dataInRow ) ;
}
Many thanks !