Combining Multiple Columns into One

[J.J.]

I would like to combine the contents of multiple columns into one column as
shown below:

apples oranges peas
pears lemons carrots

and end up with one column -

apples
pears
oranges
lemons
peas
carrots


Also, does anyone know of a searchable knowledge base of this newsgroup? I
imagine this has been asked before.

Thanks

 

[intruder9]

Can you not just cut and paste? This list is also represented here
http://www.excelforum.com/forumdisplay.php?f=

 

[J.J.]

If the task I am trying to solve was as basic as the example I posed, then
yes, copying and pasting would be an exceptable one time solution.

But it's not.

Does anybody else have an idea how to do this?

Thanks