Dynamic Array functions
All 12 functions in this category
UNIQUEReturns all distinct values from an array, removing duplicates by row or column; use it to extract clean, unique item lists from repetitive data.TOCOLFlattens an array into a single column, optionally ignoring blanks or errors and reading row-by-row or column-by-column.TOROWTOROW converts a multi-dimensional array into a single horizontal row, arranging all elements left-to-right, top-to-bottom by default.WRAPROWSWRAPROWS wraps a 1D array into multiple rows, specifying how many columns each row should contain, with optional padding for incomplete rows.WRAPCOLSWRAPCOLS reformats a single row or column of values into a multi-column array, useful for creating balanced layouts from long lists.VSTACKVSTACK combines multiple arrays or ranges by stacking them vertically into a single array, placing each input one below the other.HSTACKHSTACK combines multiple arrays horizontally (side by side) into a single rectangular array, expanding shorter arrays with blanks to create a unified output.EXPANDEXPAND enlarges an array to specified rows and columns, padding newly created cells with an optional value to create uniform-sized result tables.TAKETAKE extracts a contiguous subset of rows and columns from an array, starting from the beginning or end; use it when you need the first N items or last M items.DROPDROP removes specified rows or columns from an array, returning the rest when you need to exclude headers, skip entries, or remove unwanted fields.ARRAYTOTEXTARRAYTOTEXT converts an array into a delimited text string, with options to control separator style for easy data export.VALUETOTEXTConverts a value to its formatted text representation, supporting numbers, dates, and other value types with customizable format codes.