Formatting text into appropriate cell issue.

[manbig]

I have an issue to where I need to format one of my columns, "Customer Notes", into a single cell that corresponds with the information to the left of it. I'm looking for a way to merge all the text information for each associated record alongside the rest of the information in the same row. Since I am getting the data from a web page and importing it into excel it's not possible unfortunately to turn off line-breaks or any delimiter function that is causing the issue. I have provided an example of my data with a expected solution of what I want to achieve. If anybody can help me out I would appreciate it! Thanks!

[dflak]

I think this does what you want.

Please Login or Register  to view this content.

[manbig]

Thank you for your response dflak. Your code and proposed solution worked for me flawlessly! I can't thank you enough for helping me out with this problem