TOCOL Function

Description

Transforms an array into a single column.

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!=TOCOL(array, [ignore], [scan_by_column])
=TOCOL(array, [ignore], [scan_by_column])

EXAMPLE

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

//𝘵𝘳𝘢𝘯𝘴𝘱𝘰𝘴𝘦 𝘈1:𝘌1 𝘪𝘯𝘵𝘰 𝘴𝘪𝘯𝘨𝘭𝘦 𝘤𝘰𝘭𝘶𝘮𝘯 𝘢𝘯𝘥 𝘪𝘨𝘯𝘰𝘳𝘦 𝘣𝘭𝘢𝘯𝘬 𝘤𝘦𝘭𝘭𝘴
=TOCOL(A1:A10, 1)

//𝘤𝘰𝘯𝘷𝘦𝘳𝘵 𝘢𝘳𝘳𝘢𝘺 3𝘹4 𝘪𝘯𝘵𝘰 𝘴𝘪𝘯𝘨𝘭𝘦 𝘤𝘰𝘭𝘶𝘮𝘯.
=TOCOL(SEQUENCE(3, 4))

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

//𝘵𝘳𝘢𝘯𝘴𝘱𝘰𝘴𝘦 𝘈1:𝘌1 𝘪𝘯𝘵𝘰 𝘴𝘪𝘯𝘨𝘭𝘦 𝘤𝘰𝘭𝘶𝘮𝘯 𝘢𝘯𝘥 𝘪𝘨𝘯𝘰𝘳𝘦 𝘣𝘭𝘢𝘯𝘬 𝘤𝘦𝘭𝘭𝘴
=TOCOL(A1:A10, 1)

//𝘤𝘰𝘯𝘷𝘦𝘳𝘵 𝘢𝘳𝘳𝘢𝘺 3𝘹4 𝘪𝘯𝘵𝘰 𝘴𝘪𝘯𝘨𝘭𝘦 𝘤𝘰𝘭𝘶𝘮𝘯.
=TOCOL(SEQUENCE(3, 4))

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

RELATED