SEQUENCE

The SEQUENCE formula will do what is says - it will make a sequence of numbers in many different ways. Here is a video I made that demonstrates it.

TOCOL and TOROW

TOCOL and TOROW

There are two functions to look at when changing a dataset into a column or row: TOCOL and TOROW. Both of these formulas take an entire dataset and reformat them to either a column or a row. 

In the example below, I have a dataset surrounded by a black line. To make it into a column, in the cell A2 I typed the formula =TOCOL(C8:O70). C8:O70 is the range of the data. 

When I tried TOROW, I had to add another 500 columns, so I just adjusted the range so it would fit.