Combining Multiple Columns into One

  • Thread starter Thread starter J.J.
  • Start date Start date
J

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
 
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
 
Back
Top