Moving several columns into one row

[grinnineddies]

I probably won't explain this very well but here goes. Lets say I've got four columns of numbers, say A1-A5, B1-B5, C1-C5, D1-D5. Want I want is for all these cells to be in row one. So, I select cells A2-A5, B2-B5, C2-C5, D2-D5 and drag to cell E1, hoping that the copied cells will fill in row one, but they don't. Is there a way to do that? Otherwise I have to keep copying and pasting until all the cells are in the row. I know a macro could possibly do this, but the ranges will be different each time.

Thanks for your help.

[RickDev]

Sorry, almost deleted this post while trying to clean up the spam being left. I am not an excel expert but I know a site that might be able to help you out some if no one here can.

Near the bottom of this link it has cell referencing stuff.
http://www.expresscomputeronline.com/20021...echspace1.shtml