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

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


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=524772

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

Found the answer I was looking for at ExcelForum.com