splitInColumns

Overview
Split one column in several ones passing the number of elements per row.
The number of elements to select are per row. This means that if you have 50 elements, and you want to split them in 10, you will have 5 columns of 10 row each.
Credits cost per execution
This function spends 0 credits per execution
Video example
Arguments
Array: The array (list) of cells you want to split in columns 
size: The number of elements per row you want to split the array in
Expected output
Array: The array of columns
Text example
splitInColumns(A1:A10, 3)
//[[1], [2], [3], [4], [5], [6], [7], [8], [9], [10]];
// Returns --> [ [ 1, 2, 3 ], [ 4, 5, 6 ], [ 7, 8, 9 ], [ 10 ] ]
Use cases
To split keywords, urls or any type of data per a selected number of items

selectRandomCell

indexNow

Last modified 4mo ago