Wraps a provided row or column of values into columns by a specified count.
Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.
WRAPCOLS(vector, wrap_count, [pad_with])The WRAPCOLS function takes a single-dimensional array and reshapes it into a two-dimensional array by wrapping the elements into columns. If the total number of elements is not evenly divisible by the wrap_count, the remaining cells are filled with the optional pad_with value.
=WRAPCOLS({1,2,3,4,5}, 2)Resultado: {1,3,5; 2,4,#N/A}
Wraps 5 elements into columns of 2, resulting in a 2x3 array with an error for the missing value.
If the array cannot be perfectly divided, the function will return an #N/A error for the empty cells.