I'm assuming from your example that A1 to A4 contains 1 to 4,
B1 to B4 contains 5 to 8,
And C1 to C4 contains 9 to 12.

And, you want to copy down a column, and return the numbers (cell contents)
in order.

Enter this formula anywhere, and copy down 12 rows:

=INDEX($A$1:$C$4,MOD(ROWS($1:1)-1,4)+1,ROWS($1:4)/4)

If however, I incorrectly assumed the data configuration,
And your numbers ran across the rows, so that,
A1 to D1 contains 1 to 4,
A2 to D2 contains 5 to 8
And A3 to D3 contains 9 to 12,
And, you want to copy down a column, and return the numbers (cell contents)
in order, then try this formula anywhere, and copy down 12 rows:

=INDEX($A$1:$D$3,ROWS($1:4)/4,MOD(ROWS($1:1)-1,4)+1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Saif1k" wrote in
message ...

Hi All,

I have problem to convert data from Rows to colums but i do not want to
use Transpose option because i need to do it one by one. For example:

A 1 2 3 4
B 5 6 7 8
C 9 10 11 12

I need to convert it into columns in one go..like following:
A 1
2
3
4
B 5
6
7
8
C 9
10
11
12
Any one can help me please in this issue...if you can guide me which
formula should i use...

BR// Saif


--
Saif1k
------------------------------------------------------------------------
Saif1k's Profile:
http://www.excelforum.com/member.php...o&userid=30242
View this thread: http://www.excelforum.com/showthread...hreadid=499154