View Single Post
  #1   Report Post  
JenBasch
 
Posts: n/a
Default moving the contents of a cell


I am trying to figure out how to take the contents of cells which are
across a few columns and move them all into one long column.

Example:

|column1| |column2| |column3|
|dog.......| |bird.......| |cat.........|
|car........| |truck.....| |bus........|

Into

|column4|
dog
bird
cat
car
truck
bus

It seems like it shouldn't be too hard, but I am pretty new to excel so
any help would be greatly appreciated.

Thanks,
Jen


--
JenBasch
------------------------------------------------------------------------
JenBasch's Profile: http://www.excelforum.com/member.php...o&userid=27369
View this thread: http://www.excelforum.com/showthread...hreadid=469033