Hi!

Try this:

=OFFSET($A$1,INT((ROWS($A$1:A1)-1)/3),MOD(ROWS($A$1:A1)-1,3))

Copy down until you get zeros.

Then do a copy/paste special/values to get rid of the formulas.

Biff

"JenBasch" wrote in
message ...

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