Dynamic Array Functions
All these functions were added in Microsoft 365.
| CHOOSECOLS | (2022) The array with just a specific number of columns. |
| CHOOSEROWS | (2022) The array with just a specifiic number of rows. |
| DROP | (2022) The array without certain rows or columns. |
| EXPAND | (2022) The array expanded or padded to specific dimensions. |
| GROUPBY | (2023) Preview. The grouping of your data along one axis and aggregates the associated values. |
| HSTACK | (2022) The array after putting multiple arrays next to each other. |
| PIVOTBY | (2023) Preview. The grouping of your data along two axis and aggregates the associated values. |
| TAKE | (2022) The intersection of specific rows and columns in an array. |
| TOCOL | (2022) The array transformed into a single column. |
| TOROW | (2022) The array transformed into a single row. |
| TRIMRANGE | (2024) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range. |
| VSTACK | (2022) The array after putting multiple arrays on top of each other. |
| WRAPCOLS | (2022) The array transformed into multiple columns. |
| WRAPROWS | (2022) The array transformed into multiple rows. |
| CHOOSECOLS (2022) The array with just a specific number of columns. |
| CHOOSEROWS (2022) The array with just a specifiic number of rows. |
| DROP (2022) The array without certain rows or columns. |
| EXPAND (2022) The array expanded or padded to specific dimensions. |
| GROUPBY (2023) Preview. The grouping of your data along one axis and aggregates the associated values. |
| HSTACK (2022) The array after putting multiple arrays next to each other. |
| PIVOTBY (2023) Preview. The grouping of your data along two axis and aggregates the associated values. |
| TAKE (2022) The intersection of specific rows and columns in an array. |
| TOCOL (2022) The array transformed into a single column. |
| TOROW (2022) The array transformed into a single row. |
| TRIMRANGE (2024) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range. |
| VSTACK (2022) The array after putting multiple arrays on top of each other. |
| WRAPCOLS (2022) The array transformed into multiple columns. |
| WRAPROWS (2022) The array transformed into multiple rows. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext