One way ..

Assuming source data in cols A to E, from row1 down
with empty cols to the right

Put in F1: =A1&B1
Put in G1: =C1, copy G1 to I1
Select F1:I1, copy down until the last row of source data

Put in J1:
=OFFSET($F$1,INT((ROWS($A$1:A1)-1)/4),MOD(ROWS($A$1:A1)-1,4))

Put in K1:
=IF(MOD(ROWS($A$1:A1)-1,4)=0,LEFT(J1,1),J1)

Put in L1:
=IF(MOD(ROWS($A$1:A1)-1,4)=0,RIGHT(J1,1),"")

Select J1:L1, copy down as far as required to exhaust the data extract

The required results will be returned in cols K and L

Clean-up by selecting cols F to L, then do an "in-place":
Copy Paste special check "Values" OK
to kill all the formulas, then delete cols F to J
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"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