Array Functions

CHOOSECOLS	(Microsoft 365) The array with just a specific number of columns.
CHOOSEROWS	(Microsoft 365) The array with just a specifiic number of rows.
DROP	(Microsoft 365) The array without certain rows or columns.
EXPAND	(Microsoft 365) The array expanded or padded to specific dimensions.
GROUPBY	(Microsoft 365) The grouping of your data along one axis and aggregates the associated values.
HSTACK	(Microsoft 365) The array after putting multiple arrays next to each other.
PIVOTBY	(Microsoft 365) The grouping of your data along two axis and aggregates the associated values.
TAKE	(Microsoft 365) The intersection of specific rows and columns in an array.
TOCOL	(Microsoft 365) The array transformed into a single column.
TOROW	(Microsoft 365) The array transformed into a single row.
VSTACK	(Microsoft 365) The array after putting multiple arrays on top of each other.
WRAPCOLS	(Microsoft 365) The array transformed into multiple columns.
WRAPROWS	(Microsoft 365) The array transformed into multiple rows.

CHOOSECOLS (Microsoft 365) The array with just a specific number of columns.
CHOOSEROWS (Microsoft 365) The array with just a specifiic number of rows.
DROP (Microsoft 365) The array without certain rows or columns.
EXPAND (Microsoft 365) The array expanded or padded to specific dimensions.
GROUPBY (Microsoft 365) The grouping of your data along one axis and aggregates the associated values.
HSTACK (Microsoft 365) The array after putting multiple arrays next to each other.
PIVOTBY (Microsoft 365) The grouping of your data along two axis and aggregates the associated values.
TAKE (Microsoft 365) The intersection of specific rows and columns in an array.
TOCOL (Microsoft 365) The array transformed into a single column.
TOROW (Microsoft 365) The array transformed into a single row.
VSTACK (Microsoft 365) The array after putting multiple arrays on top of each other.
WRAPCOLS (Microsoft 365) The array transformed into multiple columns.
WRAPROWS (Microsoft 365) The array transformed into multiple rows.