Results 1 to 2 of 2

Thread: Divide text cells into different rows

  1. #1

    Divide text cells into different rows



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    My excel file consists of different columns with information. One column only consists of statements from subjects. Due to different meanings in one statement, we need to divide some of those statements so that we need to divide one row in for example 2 rows. Here is an example:
    Original version:

    Column A Column B
    Speaker 1 Hello, my name is speaker one. What is you name?
    Speaker 2 My name is speaker 2

    Version we strive for:
    Column A Column B
    Speaker 1 Hello, my name is speaker one.
    Speaker 1 What is your name?
    Speaker 2 My name is speaker 2

    One problem is, that I would need to create a new row in the second version without overwriting the next row.

    I know this is possible using the text to column function and then copy the columns into rows. Since we have 8000 statements, this would be too labor intensive. I hope someone has a great idea how to do that in a few steps. This would be so great and would save us a lot of time! So thank you very much in advance!

    Martin

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,722
    Articles
    0
    Excel Version
    2010 on Xubuntu

Tags for this Thread

Posting Permissions

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