View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
raj74 raj74 is offline
external usenet poster
 
Posts: 24
Default Rearranging DATA

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