One play ..

Assume source data is in Sheet1, A1:AX30

In Sheet2

Put in A1:

=OFFSET(INDIRECT("Sheet1!"&CHAR(INT((ROWS(Sheet1!$ A$1:A1)-1)/30)+65)&"1"),MO
D(ROWS(Sheet1!$A$1:A1)-1,30),)

Copy A1 down to A780

(Above strips cols A to Z)

Put in A781:

=OFFSET(INDIRECT("Sheet1!A"&CHAR(INT((ROWS(Sheet1! $A$1:A1)-1)/30)+65)&"1"),M
OD(ROWS(Sheet1!$A$1:A1)-1,30),)

Copy A781 down to A1500

(Above strips cols AA to AX)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"jims" wrote in message
...
I have data in 50 columns and 30 rows.
I would like to know how to either copy or move the data in the next
columns
to the next row of the previous column without using "copy and paste"
because
there are too many columns and I think there is a better way to do this.

What I mean is that I want to have only one column combining all data from
50 different columns into one column.

So it looks like this after moving or copying the data from columns into
one
column.

column A
------------
A1
...
A30
B1 ( data in the column B is now in the next row in the column A at the
31st
row)
...
B30
.....
...
AX1 ( data in the column AX is now in the next row in the column A at the
1471st row)

...
Ax30



Thank you
Jim