## 'Array manipulation' category

You are here: Excel » Functions » Array manipulation »

Subcategories

• CHOOSECOLS function (1)
• CHOOSEROWS function (1)
• DROP function (1)
• EXPAND function (1)
• HSTACK function (1)
• TAKE function (1)
• TOCOL function (3)
• TOROW function (2)
• VSTACK function (1)
• WRAPCOLS function (1)
• WRAPROWS function (1)

• Extract a unique distinct list across multiple columns and rows sorted based on frequency
Cell range B2:E11 contains values, the formula in cell B15 extracts unique distinct values in B2:E11, ignores blanks, and returns […]
How to use the EXPAND function
The EXPAND function increases a cell range or array by a specified number of columns and rows. Dynamic array formula […]
How to use the CHOOSECOLS function
The CHOOSECOLS function returns given columns from a cell range or array. Dynamic array formula in cell B9: =CHOOSECOLS(B2:D5, 2, […]
How to use the CHOOSEROWS function
The CHOOSEROWS function returns given rows from a cell range or array. Dynamic array formula in cell B9: =CHOOSEROWS(B2:D5, 2, […]
How to use the DROP function
The DROP function removes a given number of rows or columns from a 2D cell range or array. Dynamic array […]
How to use the TAKE function
The TAKE function returns a given number of rows or columns from a 2D cell range or array. Dynamic array […]
How to use the WRAPCOLS function
The WRAPCOLS function rearranges values from a single row to a 2D cell range based on a given number of […]
How to use the WRAPROWS function
The WRAPROWS function rearranges values from a single row to a 2D cell range. Dynamic array formula in cell B8: […]
How to use the TOROW function
The TOROW function rearranges values from a 2D cell range to a single row. Dynamic array formula in cell B8: […]
How to use the TOCOL function
The TOCOL function lets you rearrange values in a 2D cell range to a single column. Dynamic array formula in […]
How to use the HSTACK function
The HSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell to the […]
How to use the VSTACK function
The VSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell at the […]
Rearrange values in a cell range to a single column