Moving multiple columns data to single column

[Riaz]

Hi,
Ive been stuck at this thing for a while now. I found ways
to do the
vice versa but not this.

I have text in 180 columns (40 rows in each column). I
need to move
all the text from B1:B40 C1:C40 ... below the text in
Column A (should
start at A41). So everything shows up in one column!

Another scenario is that I have 180 rows of text in Column
A. I need
to take each cell and make 39 more copies of it in the
same column.

For example:

Column A
123
234
456

Should show up as:

Column A
123
123
123
..
..
..
234
234
234
..
..
..
456
456
456
..
..
..

So basically each text cell is repeated 40 times before
the next one
shows up.
Any help in these matters would be greatly appreciated!
Thanks
Riaz