Combine two or more rows between two words (datasource with random carriage returns)

I'm pulling book data from OCLC WorldCat which is uneven, at best, when it comes to the book Title. What I need is to identify the portion of the Title that is getting knocked into Column1.1 prior to...