Split Multi line Cell text Into Multiple Rows in range

  • Hi all, please find the attached file. I have data in column B and each cell has multiple line items. I need this in a separate row and also i need the data of the cell in A to placed with it. Thanks in advance.

    Files

    • Test.xlsx

      (9.64 kB, downloaded 100 times, last: )
  • Try:

    In the file you posted, I deleted the first 2 rows in the sheet so that the headers are in row 1.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.