WRAPCOLS Function

Description

Converts a single col/column into a two-dimensional array.

NOTE

• The column is padded with pad_with if there are insufficient elements to fill it.
• Column is filled priority. If wrap_count is greater or equal to the size of vector, then the vector is simply returned in a single column.

Syntax

Copied!=WRAPCOLS(vector, wrap_count, [pad_with])
=WRAPCOLS(vector, wrap_count, [pad_with])

EXAMPLE

Copied![𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘱𝘢𝘥_𝘸𝘪𝘵𝘩 = #𝘕𝘈

//𝘛𝘳𝘢𝘯𝘧𝘰𝘳𝘮 𝘈1:𝘈10 𝘪𝘯𝘵𝘰 4 𝘳𝘰𝘸𝘴 𝘸𝘪𝘵𝘩 𝘥𝘦𝘧𝘢𝘶𝘭𝘵 𝘱𝘢𝘥_𝘸𝘪𝘥𝘵𝘩.
=WRAPCOLS(A1:A10, 4)

//𝘛𝘳𝘢𝘯𝘧𝘰𝘳𝘮 𝘢𝘳𝘳𝘢𝘺 8 𝘹 1 𝘪𝘯𝘵𝘰 3 𝘳𝘰𝘸𝘴 𝘸𝘪𝘵𝘩 𝘢𝘥𝘥𝘦𝘥 𝘷𝘢𝘭𝘶𝘦 = '-'
=WRAPCOLS(SEQUENCE(8), 3, "-")
[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘱𝘢𝘥_𝘸𝘪𝘵𝘩 = #𝘕𝘈

//𝘛𝘳𝘢𝘯𝘧𝘰𝘳𝘮 𝘈1:𝘈10 𝘪𝘯𝘵𝘰 4 𝘳𝘰𝘸𝘴 𝘸𝘪𝘵𝘩 𝘥𝘦𝘧𝘢𝘶𝘭𝘵 𝘱𝘢𝘥_𝘸𝘪𝘥𝘵𝘩.
=WRAPCOLS(A1:A10, 4)

//𝘛𝘳𝘢𝘯𝘧𝘰𝘳𝘮 𝘢𝘳𝘳𝘢𝘺 8 𝘹 1 𝘪𝘯𝘵𝘰 3 𝘳𝘰𝘸𝘴 𝘸𝘪𝘵𝘩 𝘢𝘥𝘥𝘦𝘥 𝘷𝘢𝘭𝘶𝘦 = '-'
=WRAPCOLS(SEQUENCE(8), 3, "-")

|    | A | B | C |
|----|---|---|---|
| 1​  | 1 | 4 | 7 |
| 2  | 2 | 5 | 8 |
| 3  | 3 | 6 | - |

RELATED