Re: Convert rows to one single long column?

Tech-Archive recommends: Fix windows errors by optimizing your registry

You can use a formula, assuming that the data starts in A1 you can use this for a 5 column

=OFFSET($A$1,CEILING(ROW(1:1)/5,1)-1,MOD(ROW(5:5),5))

copy down as long as needed will return

A1
B1
C1
D1
E1
A2
B2
and so on

replace A1 with the upper left most cell, when done copy and paste special as values in place

--
Regards,

Peo Sjoblom

(No private emails please)


"Spalding" <Spalding.1ytk4m_1132530001.2959@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:Spalding.1ytk4m_1132530001.2959@xxxxxxxxxxxxxxxxxxxxxxxx 

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?action=getinfo&userid=8634
View this thread: http://www.excelforum.com/showthread.php?threadid=486720


.

Quantcast