Home Join/Login Ask Answer Subjects Members FAQ About Us
     
         
 

Guest
Guest

MS Excel - Separating one long column to several smaller columns in 16 row intervals


I have an extremely long list of data, every data point is different. I would like to separate the data from one long column to several shorter columns. Every 16 rows, I would like for the long column to "split" into the smaller column.

ex.
1
2
3
4
5
infinity

to:

1 30 46
2 31 47
.. .. ..
16 32 48

etc.


Subject(s): computer  
Asked by:Guest, 79 day(s) ago
 
AddThis Social Bookmark Button
Sort By : 
 
Home | About us | FAQ | Site map | Terms & Conditions | Contact Us
© OneBigU 2007