Array Functions

DROP(Microsoft 365) The subset of continuous rows or columns from array start or end.
EXPAND(Microsoft 365) The array expanded or padded to specific dimensions.
HSTACK(Microsoft 365) The horizontal array formed by appending the array arguments.
TAKE(Microsoft 365) The subset of contiguous rows or columns from the start or end of an array.
TOCOL(Microsoft 365) The column vector containing all the items in an array.
TOROW(Microsoft 365) The row vector containing all the items in an array.
VSTACK(Microsoft 365) The vertical array formed by appending the array arguments.
WRAPCOLS(Microsoft 365) The column vector converted into a 2-dimensional array by column.
WRAPROWS(Microsoft 365) The row vector converted into a 2-dimensional array by row.
DROP
(Microsoft 365) The subset of continuous rows or columns from array start or end.
EXPAND
(Microsoft 365) The array expanded or padded to specific dimensions.
HSTACK
(Microsoft 365) The horizontal array formed by appending the array arguments.
TAKE
(Microsoft 365) The subset of contiguous rows or columns from the start or end of an array.
TOCOL
(Microsoft 365) The column vector containing all the items in an array.
TOROW
(Microsoft 365) The row vector containing all the items in an array.
VSTACK
(Microsoft 365) The vertical array formed by appending the array arguments.
WRAPCOLS
(Microsoft 365) The column vector converted into a 2-dimensional array by column.
WRAPROWS
(Microsoft 365) The row vector converted into a 2-dimensional array by row.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top