TOROW Function

Description

Transforms an array into a single row.

NOTE

• Allow to change the cell order and ignore certain types of values (blanks and errors).
• The source array should not be too large.

Syntax

Copied!=TOROW(array, [ignore], [scan_by_column])
=TOROW(array, [ignore], [scan_by_column])

EXAMPLE

Copied![𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘪𝘨𝘯𝘰𝘳𝘦=0 [0,1,2], 𝘴𝘤𝘢𝘯_𝘣𝘺_𝘤𝘰𝘭𝘶𝘮𝘯=0 [0,1]

//𝘵𝘳𝘢𝘯𝘴𝘱𝘰𝘴𝘦 𝘈1:𝘈10 𝘪𝘯𝘵𝘰 𝘳𝘰𝘸 𝘢𝘯𝘥 𝘪𝘨𝘯𝘰𝘳𝘦 𝘣𝘭𝘢𝘯𝘬 𝘤𝘦𝘭𝘭𝘴
=TOROW(A1:A10, 1)

//𝘤𝘰𝘯𝘷𝘦𝘳𝘵 𝘢𝘳𝘳𝘢𝘺 3𝘹4 𝘪𝘯𝘵𝘰 𝘳𝘰𝘸.
=TOROW(SEQUENCE(3, 4))

//𝘵𝘳𝘢𝘯𝘴𝘧𝘰𝘳𝘮 𝘭𝘢𝘴𝘵 3 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘧𝘳𝘰𝘮 𝘈1:𝘌10 𝘵𝘰 𝘳𝘰𝘸, 𝘪𝘨𝘯𝘰𝘳𝘦 𝘣𝘭𝘢𝘯𝘬𝘴 & 𝘦𝘳𝘳𝘰𝘳 𝘢𝘯𝘥 𝘴𝘤𝘢𝘯 𝘣𝘺 𝘤𝘰𝘭𝘶𝘮𝘯
=TOROW(TAKE(A1:E10, -3), 2, 1)
[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘪𝘨𝘯𝘰𝘳𝘦=0 [0,1,2], 𝘴𝘤𝘢𝘯_𝘣𝘺_𝘤𝘰𝘭𝘶𝘮𝘯=0 [0,1]

//𝘵𝘳𝘢𝘯𝘴𝘱𝘰𝘴𝘦 𝘈1:𝘈10 𝘪𝘯𝘵𝘰 𝘳𝘰𝘸 𝘢𝘯𝘥 𝘪𝘨𝘯𝘰𝘳𝘦 𝘣𝘭𝘢𝘯𝘬 𝘤𝘦𝘭𝘭𝘴
=TOROW(A1:A10, 1)

//𝘤𝘰𝘯𝘷𝘦𝘳𝘵 𝘢𝘳𝘳𝘢𝘺 3𝘹4 𝘪𝘯𝘵𝘰 𝘳𝘰𝘸.
=TOROW(SEQUENCE(3, 4))

//𝘵𝘳𝘢𝘯𝘴𝘧𝘰𝘳𝘮 𝘭𝘢𝘴𝘵 3 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘧𝘳𝘰𝘮 𝘈1:𝘌10 𝘵𝘰 𝘳𝘰𝘸, 𝘪𝘨𝘯𝘰𝘳𝘦 𝘣𝘭𝘢𝘯𝘬𝘴 & 𝘦𝘳𝘳𝘰𝘳 𝘢𝘯𝘥 𝘴𝘤𝘢𝘯 𝘣𝘺 𝘤𝘰𝘭𝘶𝘮𝘯
=TOROW(TAKE(A1:E10, -3), 2, 1)

RELATED