All Content
Timespan
9 Exciting NEW Excel Functions for Shaping Arrays - Incredible!
Oct 9, 2022 12:00 AM

9 Exciting NEW Excel Functions for Shaping Arrays - Incredible!

External YouTube Channel

In this video I cover 9 new array shaping Excel functions

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:

https://www.myonlinetraininghub.com/new-array-shaping-excel-functions

Excel EXPAND Function

Expands or pads an array to a specified number of rows and columns.

https://www.myonlinetraininghub.com/excel-functions/excel-expand-function

Excel TOROW Function

Returns the array in a single row. Useful for combining data across multiple columns and rows into a single row.

https://www.myonlinetraininghub.com/excel-functions/excel-torow-function

Excel TOROW Function

Returns the array in a single column. Useful for combining data across multiple columns and rows into a single column.

https://www.myonlinetraininghub.com/excel-functions/excel-torow-function

WRAPROWS Function Syntax

Lets you wrap (reshape) a row or column of values into rows, you specify the number of values in each row.

https://www.myonlinetraininghub.com/excel-functions/excel-wraprows-function

WRAPCOLS Function

The Excel WRAPCOLS function restructures an array or range into columns, you specify the number of values in each column.

https://www.myonlinetraininghub.com/excel-functions/excel-wrapcols-function

Excel DROP Function

Remove a specified number of contiguous rows or columns from the start or end of an array.

https://www.myonlinetraininghub.com/excel-functions/excel-drop-function

Excel TAKE Function

Extract a specified number of contiguous rows or columns from the start or end of an array.

https://www.myonlinetraininghub.com/excel-functions/excel-take-function

Excel CHOOSEROWS Function

Extract rows from the specified column or columns.

https://www.myonlinetraininghub.com/excel-functions/excel-chooserows-function

Excel CHOOSECOLS Function

The Excel CHOOSECOLS function allows you to extract columns from a range or array.

https://www.myonlinetraininghub.com/excel-functions/excel-choosecols-function

Excel VSTACK and HSTACK Functions

Combine arrays arranged horizontally (HSTACK) into a new single array.

Combine arrays arranged vertically (VSTACK) into a new single array.

https://www.myonlinetraininghub.com/excel-vstack-and-hstack-functions