how to put data in the column A to the next row of the column B

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.

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)
....
B30
......
....
AX1 ( data in the column AX is now in the next row in the column A)

....
Ax30



Thank you
Jim

.

Relevant Pages

  • how to combine several columns into a single column
    ... AX1 (data in the column AX is now in the next row in the column A at the ... Ax30 ... Jim ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: Formula Help with Lists
    ... >> I need to be able to pull a list from series of data without sorting or ... >> John in A8? ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Rules Wizard - delay in running VBA macro
    ... My box is not under any load, ... assumption is the script should fire immediately. ... Jim ... Prev by Date: ...
    (microsoft.public.office.developer.outlook.vba)
  • Re: OT - overpaid CEOs
    ... be other CEOs of other corporations. ... It's a mutual back-scratching ... Jim ... Prev by Date: ...
    (rec.crafts.metalworking)