HELP PLEASE!

I have a large excel spreadsheet. The layout is like this:

A SDF ED
B EFD BR
C ERT RT

How do I transpose everything using VB so they are in one column lik
this:

A
SDF
ED
B
EFD
BR
C
ERT
RT

THANKS A LOT!

--
sunj9
-----------------------------------------------------------------------
sunj99's Profile: http://www.excelforum.com/member.php...fo&userid=2393
View this thread: http://www.excelforum.com/showthread.php?threadid=37566