How do I insert rows between sorted data

[Guest]

I have a file of 10000+ sorted rows. How do I insert a row between each
sorted category without inserting a row manually?

 

[Dave Peterson]

Maybe data|subtotals???

I have a file of 10000+ sorted rows. How do I insert a row between each
sorted category without inserting a row manually?

 

[Pete_UK]

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