+ Reply to Thread
Results 1 to 6 of 6

Row to multiple rows and auto numbering............

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    wv
    MS-Off Ver
    Excel 2010
    Posts
    13

    Row to multiple rows and auto numbering............

    i have a data that looks like this

    A B C D E F G H I J K L M N O P...........AF
    aa aa aa aa bb aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa ccmnyd aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa ddjkd aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa ejklaaa aa aa aa aa aa aa aa aa aa aa aa...........
    .
    .
    .
    .
    like up to 80,000 files
    and solution has to be like this....
    A B C D o E F G H I J K L M N O P...........AF
    aa aa aa aa 1 b aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 2 b aa aa aa aa aa aa aa aa aa aa aa...........

    aa aa aa aa 1 c aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 2 c aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 3 m aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 4 n aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 5 y aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 6 d aa aa aa aa aa aa aa aa aa aa aa...........

    aa aa aa aa 1 d aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 2 d aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 3 j aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 4 k aa aa aa aa aa aa aa aa aa aa aa...........
    aa aa aa aa 5 d aa aa aa aa aa aa aa aa aa aa aa...........


    Actually, all the "aa" i mentioned are not the same data they are of different values. so anyone please tell me the macro for this so that i can save some time and i am new to vb so please help me,
    one more thing is i tried some code and i could split the data but i could get the numbering because every record has different number of rows, so i could not give the numbering based on how many rows it has split to...............
    please help me...........

    Thank you all......

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Row to multiple rows and auto numbering............

    Post a sample workbook describing the outcome you need, with the same layout that you have the data formatted in.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    wv
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Row to multiple rows and auto numbering............

    HELLO,

    The above data i have given is the raw data and the below sequence is outcome , probably i have not mentioned but it is ,i'm sorry about that.

  4. #4
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Row to multiple rows and auto numbering............

    I still can't see what is going on. Cheers

  5. #5
    Registered User
    Join Date
    06-26-2012
    Location
    wv
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Row to multiple rows and auto numbering............

    Ok if you observe the field "g"
    in raw data u could see "bb","ccmnyd"...........
    But in the solution it is like
    1 b
    2 b

    and
    1 c
    2 c
    3 m
    4 n
    5 y
    6 d
    ..
    And also the numbering has to be given based on like in to how many rows it is dividing and the number has to appear in a different column...........hope u got my point or else feel free to reply............

  6. #6
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Row to multiple rows and auto numbering............

    Maybe I am missing something, but I would much rather see the actual data and how it is formatted in the sheet. On top of that it will make things easier to debug when writing the code.

+ 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