WRAPROWS Function

Description

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

NOTE

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

Syntax

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

EXAMPLE

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

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

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

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

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

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

RELATED