12 columns by 8 rows to one row

[nate hubert]

The following formula works well to convert a table of multipl
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 ro
instead of one column

Please

 

[Pete_UK]

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