Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Fix two rows in a series

    I have a great deal of data in column A that all looks like this:



    Every 7th row needs to be split into two rows with the other data below it, like this:

    09/10/2001
    BUTLER, DANIEL

    Any quick ideas??

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K,

    I count only 6 rows of data? Is there a blank row between entries? Or did you mean there would be 7 after the split?
    Do you want the sub items in Col B or indented in Col A? This will be pretty easy to do with some simple VBA with the answers to the questions.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    There are six rows in each set or block. I want a new column that splits the 1st entry of each block into two rows.
    Therefore, the result will have 7 rows per block. Each new block in column A is increments of 7 (i.e., 1, 7, 13, etc.)

    There are no blanks between the blocks.
    Last edited by kweaver; 2011-11-14 at 17:10. Reason: add'l info

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K,

    Ok, the attached worksheet does this and adds an indent on the bottom 5 entries of each section. You can comment out the part of the macro that does that if you don't want it. Just copy the macro from the sheet to your data.
    The one assumption I made is that there is no data below the last of the groups of 6 rows.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    NICE! Thanks.

Posting Permissions

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