Posts

Showing posts from November, 2024

TOCOL and TOROW

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