Data Functions

ARRAYTOTEXT	The contents of an array or cell range converted to text.
CHOOSE	The value in a row (or column) based on an index number.
CHOOSECOLS	The array with just a specific number of columns.
CHOOSEROWS	The array with just a specific number of rows.
COPILOT	The response based on your referenced data using an AI model.
DROP	The array without certain rows or columns.
EXPAND	The array expanded or padded to specific dimensions.
FILTER	The array after filtering data in a range that satisfies multiple conditions.
HSTACK	The array after putting multiple arrays next to each other.
GETPIVOTDATA	The data obtained from a pivot table.
SORTBY	The array of data that has been sorted based on multiple columns.
TAKE	The array from taking the intersection of specific rows and columns.
TOCOL	The array transformed into a single column.
TOROW	The array transformed into a single row.
TRIMRANGE	The array after excluding all empty rows and/or columns from the outer edges of a range.
UNIQUE	The array of unique values in a list, table or cell range.
VSTACK	The array after putting multiple arrays on top of each other.
WRAPCOLS	The array transformed into multiple columns.
WRAPROWS	The array transformed into multiple rows.

ARRAYTOTEXT The contents of an array or cell range converted to text.
CHOOSE The value in a row (or column) based on an index number.
CHOOSECOLS The array with just a specific number of columns.
CHOOSEROWS The array with just a specific number of rows.
COPILOT The response based on your referenced data using an AI model.
DROP The array without certain rows or columns.
EXPAND The array expanded or padded to specific dimensions.
FILTER The array after filtering data in a range that satisfies multiple conditions.
HSTACK The array after putting multiple arrays next to each other.
GETPIVOTDATA The data obtained from a pivot table.
SORTBY The array of data that has been sorted based on multiple columns.
TAKE The array from taking the intersection of specific rows and columns.
TOCOL The array transformed into a single column.
TOROW The array transformed into a single row.
TRIMRANGE The array after excluding all empty rows and/or columns from the outer edges of a range.
UNIQUE The array of unique values in a list, table or cell range.
VSTACK The array after putting multiple arrays on top of each other.
WRAPCOLS The array transformed into multiple columns.
WRAPROWS The array transformed into multiple rows.