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