Functions
WRAPROWS
Wraps a vector into rows of the given length
Try it
When to use it
When should I use WRAPROWS?
Use WRAPROWS to reshape a flat vector into a multi-row array of a fixed row width — useful for paginating a sequential list into fixed-width rows for display or matrix operations.
Used in
Syntax
WRAPROWS(vector, wrap_count, [pad_with])Examples
=WRAPROWS({1,2,3,4,5,6},2) // => 1
=WRAPROWS({1,2,3,4,5,6},3) // => 1
=WRAPROWS({1,2,3,4},1) // => 1