convert row list to table

[palaeontology]

I have a list of values in the column range C32 to C800.

I have a formula I use to convert a the column list to a table just 10 columns wide starting in cell L32 ...

=OFFSET($C$32,COLUMNS($L$32:L32)-1+(ROWS($32:32)-1)*10,0)

However, I now have a row list in the range L5:BI5, and would like to convert it to a table 10 columns wide, but I can't figure how to arrange the formula accordingly.

Can anyone point me in the right direction ?

Kind regards,

Chris

 

[Eric W]

Try:

=OFFSET($L$5,0,COLUMNS($L$5:L5)-1+(ROWS($5:5)-1)*10)

Same formula, just switching the calculation from the row offset parameter to the column offset parameter.

 

[Peter_SSs]

I would avoid the volatile function OFFSET and do it like this, copied across and down.

Excel Workbook
	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
5	L5	M5	N5	O5	P5	Q5	R5	S5	T5	U5	V5	W5	X5	Y5	Z5	AA5
6
7
8	L5	M5	N5	O5	P5	Q5	R5	S5	T5	U5
9	V5	W5	X5	Y5	Z5	AA5	AB5	AC5	AD5	AE5
10	AF5	AG5	AH5	AI5	AJ5	AK5	AL5	AM5	AN5	AO5
11	AP5	AQ5	AR5	AS5	AT5	AU5	AV5	AW5	AX5	AY5
12	AZ5	BA5	BB5	BC5	BD5	BE5	BF5	BG5	BH5	BI5
Row to Column