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

Last updated