+ Reply to Thread
Results 1 to 3 of 3

Separating data with multiple delimiters into columns AND rows

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    Norfolk, Va
    MS-Off Ver
    Excel 2007
    Posts
    9

    Separating data with multiple delimiters into columns AND rows

    Hello! I have a Bill of Materials (parts explosion) spreadsheet with data in columns A,B,C,D,E,F&G. Column A is the main part number of the item to build. B is its description, column C is a string of delimited information that follows this format: qty\sub-part number\description/qty\sub-part number\description/qty\sub-part number\description/
    for example: 1\200786\BOX/1\300298\COVER/1\MS28775-254\GASKET/1\4TB8\TBrD/
    These are the sub parts that go into making the item in column A. The information in columns B,D,E,F& G are specific to the main part number in column A and must remain in the same ROW as the main part number.
    However, I need the data string in column C to be separated into columns (by qty, part number and description), insert a row underneath and continue separating the data so that only one qty, sub-part number and description is in each row underneath, and a new row is inserted for each sub-part number.

    I have posted example worksheets on www.4shared.com

    http://www.4shared.com/file/vHpXokDV/Unfixed.html shows the spreadsheet as it exists now, though much smaller!

    http://www.4shared.com/file/9t-xJ-O0/Fixed.html shows how I need to break down the data in the "Unfixed" column C.

    I'd really appreciate anyone's help with this!!
    Thanks!!

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Separating data with multiple delimiters into columns AND rows

    Please attach a sample book in excel format, not link. One book, with one sheet as raw data and another as output will do.

  3. #3
    Registered User
    Join Date
    03-02-2011
    Location
    Norfolk, Va
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Separating data with multiple delimiters into columns AND rows

    Thank you, but I finally figure this one out!

+ 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