I have a file of 10000+ sorted rows. How do I insert a row between each
sorted category without inserting a row manually?
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:
>
> 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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks