How do I insert rows between sorted data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file of 10000+ sorted rows. How do I insert a row between each
sorted category without inserting a row manually?
 
If you wanted the extra rows to be completely blank, then use a helper
column and fill it with a sequence from 1 to 10,000+. Then copy this
column of data immediately below itself. Then select the your data area
including the helper column down to what will now be 20,000+ rows and
sort on the helper column and the original sort column. You can then
delete the helper column.

Hope this helps.

Pete
 
Back
Top