+ Reply to Thread
Results 1 to 3 of 3

Need help moving multiple lines of data in single cell to unique subsequent rows

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need help moving multiple lines of data in single cell to unique subsequent rows

    Hi there! My name is Brett. This is my first time posting in this forum.

    I have an issue where I have a rows of data with six columns. One of the columns has multiple lines of data in a single cell. I need to turn each line into its own unique row while preserving the other columns to remain in the first row. Here is an example of what my "as-is" worksheet looks like:

    Capture.JPG


    This is what my "to-be" worksheet needs to look like:

    Capture2.JPG

    I need to do this for ~12,000 rows in my worksheet. I am not good with marcos and am assuming that's what I'll need to use to accomplish this task. Any help would be greatly appreciated. I'll attach the Workbook (document 5) with two tabs (As-Is and To-Be).

    Also, I am using Excel 2007
    Attached Files Attached Files
    Last edited by brettmburns; 12-19-2012 at 05:19 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,034

    Re: Need help moving multiple lines of data in single cell to unique subsequent rows

    Try the attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-19-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need help moving multiple lines of data in single cell to unique subsequent rows

    jindon! Thanks so much!!! This works perfectly!

+ 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