+ Reply to Thread
Results 1 to 2 of 2

Comma delimited data in multiple cells to rows

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    5

    Comma delimited data in multiple cells to rows

    Good Day:

    I have a simple table for Year, Make, Model and Engine. However, each cell can contain multiple comma delimited data that needs broken out by row with corresponding comma delimited data in adjacent cells.

    If I have 4 "YEARS", 2 "MAKES:, 12 "MODELS" AND 2 "ENGINE", how do I get a row consisting of the 1st "YEAR" value, the 1st "MAKE", the 1st "MODEL", then the 1st "ENGINE", then the 2nd "YEAR", to the 2nd "MAKE", and 2nd "MODEL".....
    until each delimited value in each cell is distributed.

    The attached should help illustrate the point.

    Thank you for your consideration.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-31-2013
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Comma delimited data in multiple cells to rows

    As it usually goes, I was guided to the answer once the question had been asked. I apologize.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] comma and dash delimited data to rows
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2013, 11:01 AM
  2. Separate comma-delimited values to rows
    By sporto in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-22-2013, 10:06 AM
  3. Separate comma delimited values to rows
    By grepolis in forum Excel General
    Replies: 3
    Last Post: 01-25-2011, 01:24 PM
  4. separating values in comma delimited cells
    By JChandler22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2008, 06:31 PM
  5. Comma Delimited to Rows, Over 255 Records
    By CriticalBill in forum Excel General
    Replies: 1
    Last Post: 01-18-2008, 09:51 PM

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