In this video I cover 9 new array shaping Excel functions including TOCOL, TOROW, WRAPCOLS, WRAPROWS, TAKE, DROP, CHOOSECOLS, CHOOSEROWS and EXPAND. I also use them in some advanced techniques, which is where their real power is realised. See the timestamps below to skip to the function you want to learn.
Download the Excel and more Information:
Expands or pads an array to a specified number of rows and columns.
Returns the array in a single row. Useful for combining data across multiple columns and rows into a single row.
Returns the array in a single column. Useful for combining data across multiple columns and rows into a single column.
Lets you wrap (reshape) a row or column of values into rows, you specify the number of values in each row.
The Excel WRAPCOLS function restructures an array or range into columns, you specify the number of values in each column.
Remove a specified number of contiguous rows or columns from the start or end of an array.
Extract a specified number of contiguous rows or columns from the start or end of an array.
Extract rows from the specified column or columns.
The Excel CHOOSECOLS function allows you to extract columns from a range or array.
Combine arrays arranged horizontally (HSTACK) into a new single array.
Combine arrays arranged vertically (VSTACK) into a new single array.