Wraps a provided row or column of values into columns by a specified count.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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)Sonuç: {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.