WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.
Includes usage of the WRAPROWS and WRAPCOLS functions and examples of its use.
VSTACK and HSTACK functions.Merge multiple range of cells.(Microsoft Excel)
Includes information on the VSTACK and HSTACK functions, examples of their use, and examples of combining them with o ...
CHOOSEROWS and CHOOSECOLS functions. Obtain rows and columns at specified positions from range of cells.(Microsoft Excel)
Includes usage of the CHOOSEROWS and CHOOSECOLS functions and examples of its use.
EXPAND Function. Expand range of cells.(Microsoft Excel)
Includes usage of the EXPAND function and examples of its use.
TOROW Function. Sort range of cells into a single row.(Microsoft Excel)
Includes usage of the TOROW function and examples of its use.
TOCOL Function. Sort range of cells into a single column.(Microsoft Excel)
Includes usage of the TOCOL function and examples of its use.
TAKE Function. Get rows and columns from range of cells.(Microsoft Excel)
Includes usage of the TAKE function and examples of its use.
DROP Function. Deletes rows and columns from range of cells.(Microsoft Excel)
Includes usage of the DR OP function and examples of its use.
TEXTSPLIT function. Split text into cells by specifying a delimiter.(Microsoft Excel)
Includes usage of the TEXTSPLIT function and examples of its use.
TEXTAFTER Function. Get substrings after a specified character (Microsoft Excel)
Includes usage of the TEXTAFTER function and examples of its use.