Wraps a provided row or column of values into a two-dimensional array by row.
Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.
WRAPROWS(vector, wrap_count, [pad_with])The WRAPROWS function takes a one-dimensional array or range and reshapes it into a new array with a specified number of columns. If the total number of elements is not perfectly divisible by the wrap count, the remaining cells are filled with the optional pad_with value.
=WRAPROWS({1,2,3,4,5,6}, 2)Resultat: {1,2;3,4;5,6}
Wraps a 6-element array into 2 columns, resulting in a 3x2 array.
If the array cannot be perfectly divided, the function will return an #N/A error for the missing cells.