Results 1 to 24 of 24

Macro/Script for Moving Groups of Data in to Separate Columns

Threaded View

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    Carbondale, IL
    MS-Off Ver
    Excel 2003
    Posts
    8

    Macro/Script for Moving Groups of Data in to Separate Columns

    But I'm going to try my best...

    So here's what I have. A huge list of data in 1 column like this

    datadatadata
    datadatadata
    datadatadata

    ..................(two rows of spacing before the next 3 lines of data)
    datadatadata
    datadatadata
    datadatadata


    datadatadata
    datadatadata
    datadatadata
    ___________________
    Okay, with showing you that terrible example, here's what I need to accomplish for work.
    I need to get those 3 rows of data in separate columns right next to it, like this:

    column1........................column2........................column3
    datadatadata.................datadatadata.................datadatadata
    datadatadata.................datadatadata.................datadatadata
    datadatadata.................datadatadata.................datadatadata
    ___________________
    Is this possible to do with a script or macro?
    The initial row can stay if its a problem, so it could look like

    column 1......................column 2.......................column 3........................column 4
    datadatadata................datadatadata.................datadatadata.................datadatadata
    datadatadata
    datadatadata


    datadatadata................datadatadata.................datadatadata.................datadatadata
    datadatadata
    datadatadata


    Or whatever - I could just delete the whole first column afterwards.
    It doesn't have to be perfect at all, I just have to get a faster way to do this than copy it in to the other rows manually, a script or macro that will do a whole sheet at once would be GREAT.
    Each one of these sheets have about 1600 + rows (2 spaces in between each of the groups of data) so you can see why I haveeee to find a better way.

    If someone could throw me a bone I'd be SUPER grateful - you have no idea how grateful lol.

    Thanks in advance for trying,
    Justin






    EDIT: ADDED Attachment as requested !
    Attached Files Attached Files
    Last edited by JustinSxcel; 07-04-2012 at 01:51 PM.

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