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.