I'd prefer to use INDEX to do this, as it is not volatile. Which cells
contain your data, and which row do you want the data to appear on
(from column A of that row?) ?

Pete

On Aug 31, 5:33*pm, nate hubert
wrote:
The following formula works well to convert a table of multiple
dimensions (here four columns) to just one column.

=OFFSET($A$1,MOD(ROWS($1:1)-1,4),INT((ROWS($1:1)-1)/4))

How can you use a similar function to return the table as one row
instead of one column?

Please?

--
nate hubert