en | de
All Content
Timespan
â€‹
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