en | de
Oct 9, 2022 12:00 AM

# 9 Exciting NEW Excel Functions for Shaping Arrays - Incredible!

## 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.

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

HubSite 365 Apps