+ Reply to Thread
Results 1 to 3 of 3

How do I insert rows between sorted data

  1. #1
    Jackie
    Guest

    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?

  2. #2
    Dave Peterson
    Guest

    Re: 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

  3. #3
    Pete_UK
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1