ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I insert rows between sorted data (https://www.excelbanter.com/excel-discussion-misc-queries/78734-how-do-i-insert-rows-between-sorted-data.html)

Jackie

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?

Dave Peterson

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

Pete_UK

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