+ Reply to Thread
Results 1 to 5 of 5

Multi columns of delimited data into rows

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Toronto ,Canada
    MS-Off Ver
    Excel 2007, 2010
    Posts
    3

    Multi columns of delimited data into rows

    Hello all,

    I've been trying to find a way to seperate multiple columns of delimited test (by '; ') into new rows, with no luck what so ever, I have been able to run the macro on one column, but not multiple columns. Is this at all possible.

    I have 4 regular text columns and 6 delimited columns, the 4 regular columns are being replicated fine, the first of the delimited columns are fine, but then the last 5 delimited columns just get replicated into the new cells caused by the first split.

    I have attached the workblook I've been using, any suggestions would be greatly appretiated.

    Thanks
    DWTK
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Multi columns of delimited data into rows

    Hi,

    make sure the worksheet to be changed is activated and try this:
    Please Login or Register  to view this content.
    Regards

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Multi columns of delimited data into rows

    Another one...

    Please Login or Register  to view this content.

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

    Re: Multi columns of delimited data into rows

    try
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-16-2013
    Location
    Toronto ,Canada
    MS-Off Ver
    Excel 2007, 2010
    Posts
    3

    Re: Multi columns of delimited data into rows

    Thank you tehneXus, this was exactly what I needed. Well done. I appreciate your help in this.

    DWTK

+ 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