another way is using the Edit | Paste Sepcial |Transpose featu

1. Select and copy the data you want to transpose
2. Position the cell pointer in the first destination cell
3. Select Edit | Paste Special | Transpose
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"raj74" wrote:

I have a list of data written in col. say 105 no data in A1:A105

Now I wart to write those 105 data in rows, Each row can have maximun 10
data.The next data (11th) will go to next row. for example wehave data

A1=1
A2 =2
A3=13
A4 =12
A5=14
...
...
..
..
...
A105= 25

i want to rearrange those data in the following way

say, C1 D1 ..................................... L1 (total 10 data in
each row)
C2 D2 L2
and so on...

Where C1 = A1, D1 = A2,..........................L1= A10
C2=A11, D2 =A12..........................L2=A20
......................

Hope I can explain properly,

Thanks