Is there a nifty neato way to put a range of values into a single column without a lot of manual
cutting and pasting and without VBA programming?

For example, if I have 5 rows of numbers in columns A, B, C, D, can I select the range B1:D5 and
dump all 15 numbers into column A? The TRANSPOSE function doesn't work for this type of range.
Thanks...

Jeff