TRUECALC
Functions

WRAPCOLS

Wraps a vector into columns of the given length

Try it

When to use it

When should I use WRAPCOLS?

Use WRAPCOLS to reshape a flat vector into a multi-column array of a fixed column height — useful for converting a sequential list into a grid layout for display or further array operations.

Used in

operations

Syntax

WRAPCOLS(vector, wrap_count, [pad_with])

Examples

=WRAPCOLS({1,2,3,4,5,6},2) // => 1
=WRAPCOLS({1,2,3,4,5,6},3) // => 1
=WRAPCOLS({1,2,3,4},1) // => 1

On this page