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?
 
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?
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting blank rows 3
Sort with blank rows between data rows 1
Sum by different sorts 2
Insert formula 3
writing a sort macro 2
Sort data with blank rows dividing data 5
Update defined name ranges after sort 3
How do I insert a row between every line in my spreadsheet? 3

Back
Top