![]() |
How do I insert rows between sorted data
I have a file of 10000+ sorted rows. How do I insert a row between each
sorted category without inserting a row manually? |
How do I insert rows between sorted data
Maybe data|subtotals???
Jackie wrote: 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 |
How do I insert rows between sorted data
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 |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com