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