View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J.J.
 
Posts: n/a
Default Combining Multiple Columns into One

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