In order to convert the table to a single column do the following. The data table has been assigned the name DataTable and the column name
is ColumnData. It is sufficient to name only the first cell. Enter the
following formula in the first cell of ColumnData and fill down as many rows as there are
elements in your table:

**=OFFSET(DataTable,MOD(ROW()-ROW(ColumnData),ROWS(DataTable)),TRUNC((ROW()-ROW(ColumnData))/ROWS(DataTable),0),1,1)**

This will fill in the values from the DataTable in column-by-column order, working down then across.
You can retrieve the values from DataTable in row-by-row order order, working across then down,
with the following formula:

**=OFFSET(DataTable,TRUNC((ROW()-ROW(ColumnData))/COLUMNS(DataTable),0),MOD(ROW()-ROW(ColumnData),COLUMNS(DataTable)),1,1)**

The principle is the same: Enter the
following formula in the first cell of ColumnData and fill down as many rows as there are
elements in your table.