Lookup & Reference Function - TAKE

Use the TAKE function to extract rows and columns from a current array and present them in a new one.

The video shows the TAKE function in use.

The written calculation is below:

=TAKE(B3:D8,3,2)

​In this example, B3:D8 is the array we want to transform into another form.

3 is the number of rows we want to 'take' from the selected data.

2 is the number of columns we want to 'take' from the selected data.