Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2006

Tip: Looking for answers? Try searching our database.

Combining Multiple Columns into One

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J.J. - 21 Mar 2006 14:42 GMT
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 - 21 Mar 2006 14:57 GMT
Can you not just cut and paste?  This list is also represented here
http://www.excelforum.com/forumdisplay.php?f=
J.J. - 21 Mar 2006 16:08 GMT
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
J.J. - 21 Mar 2006 16:25 GMT
Found the answer I was looking for at ExcelForum.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.