12 columns by 8 rows to one row

N

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
 
P

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
 
Top