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. |
TRIMRANGE | (Microsoft 365) The array after excluding all empty rows and/or columns from the outer edges of a range. |
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. |
TRIMRANGE (Microsoft 365) The array after excluding all empty rows and/or columns from the outer edges of a range. |
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top