software

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

Maybe data|subtotals???

Jackie wrote:
gt;
gt; I have a file of 10000 sorted rows. How do I insert a row between each
gt; sorted category without inserting a row manually?

--

Dave Peterson

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