+ Reply to Thread
Results 1 to 3 of 3

Split rows based on Month value in Month field

  1. #1
    Registered User
    Join Date
    01-11-2007
    Posts
    94

    Split rows based on Month value in Month field

    Hi

    In my data set each single row for a company and corresponding product code it has single or multiple month values in month column. I want achieve result like result tab which takes single row, split the row based on month value if there are multiple month values.

    Thanks
    NKRA
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Split rows based on Month value in Month field

    COPY DATA IN SHEET DATASET TO A NEW SHEET CALLED SHEET3 FROM A1
    file "nkra book1.xlsm" is attached. when you open click enable macros

    the file is AFter running the macro test
    to retest just run that macro again. macro is in the module and also repeated here for those who do not like to open the file


    Please Login or Register  to view this content.
    Attached Files Attached Files
    I am not an expert. better solutions may be available
    $$$$venkat1926$$$$@gmail.com

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Split rows based on Month value in Month field

    try
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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