View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Spalding
 
Posts: n/a
Default Convert rows to one single long column?


If I have a bunch of rows with say 5 columns each, is there an easy way
to convert it to one big long column, just adding each row below the
information from the previous row after being converted to a column?
Copy and then Paste Special Transpose doesn't quite do it since it
makes multiple columns.


--
Spalding
------------------------------------------------------------------------
Spalding's Profile: http://www.excelforum.com/member.php...fo&userid=8634
View this thread: http://www.excelforum.com/showthread...hreadid=486720