table to single row
 

The following formula works well to convert a table of multiple dimensions (here four columns) to just one column (in the order i would like which is across the first row of data, starting again with the first value of the second row):

=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?

Hi,

Could you post an example workbook with a before and after so we can see exactly what you need?

12 columns by 8 rows to one row
 

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