Text to Rows

[Bkeith]

I have text in one cell that I want to have placed into multiple rows but the data in the last column needs to stay with the data that will be separated into the rows. I have attached the file before and after showing what I have and what I want.

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[jindon]

Do you want to output as .txt file?

[Bkeith]

Sorry, I thought I saved them as excel files not a txt file.

[jindon]

See attached

[Bkeith]

WOW that was quick, that seems to work perfectly. Thanks.