Results 1 to 5 of 5

Thread: Split Data in Table To Multiple Rows Based On Delimited Text In Columns

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Your input table shows two columns that have delimited value. Can you post a sample of what is the expected output.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by Excel Fox View Post
    Your input table shows two columns that have delimited value. Can you post a sample of what is the expected output.
    Actually, I cannot tell what is in his columns when I paste them into a worksheet (I get some merged cells resulting). A suggestion to nick5_86... list the cells and next to them their content, something like this...

    C1 - L1A1
    C2 - L1C1
    etc. for Column C

    D1 - L1B1,L1B2
    D2 - L1D1,L1D2
    etc. for Column D

    Although use your actual values as I am not sure the above is correct. Then show us you expected output in the same way.

Similar Threads

  1. Replies: 34
    Last Post: 03-13-2015, 02:26 PM
  2. Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  3. Replies: 2
    Last Post: 03-05-2013, 07:34 AM
  4. Replies: 2
    Last Post: 06-14-2012, 04:10 AM
  5. Split Range into Multiple Columns VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 03-07-2012, 10:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •