Quickly moving rows of 5-column groups on 1 continuous line
 

I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a
5x50 grid). I'm trying to turn this into 1 continuous row that uses data
from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3...

Is there any way to automate some of this? Thanks.

Quickly moving rows of 5-column groups on 1 continuous line
 

I assume you want the value from A1 in Column A, From B1 column B... From A2
in Column F, from B2 in Column G etc.
if so go below your data (Say row 100) and in A1100 enter
=INDIRECT("A"&CEILING(COLUMN()/5,1))
in B100 enter
=INDIRECT("B"&CEILING(COLUMN()/5,1))
continue to column E putting in appropriate letters.
copy A100:E100 and copy out to 250 columns.
"C.O." wrote:

I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a
5x50 grid). I'm trying to turn this into 1 continuous row that uses data
from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3...

Is there any way to automate some of this? Thanks.

Quickly moving rows of 5-column groups on 1 continuous line
 

Hi!

One way:

Assume your data is in the range A1:E50

Enter this formula in some cell and copy across as needed:

=OFFSET($A$1,INT((COLUMNS($A$1:A1)-1)/5),MOD(COLUMNS($A$1:A1)-1,5))

Biff

"C.O." wrote in message
...
I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a
5x50 grid). I'm trying to turn this into 1 continuous row that uses data
from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3...

Is there any way to automate some of this? Thanks.