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...