While bringing in text from another source, excel seems to move back and forth a cell every once in a while. I have thousands of lines to clean up so I'm looking for an easier way. Below is an example of what I have and then an example of what I'd like. My issue is I can manually do it easily but I don't know how to do it all at once.
While of course I'd like a solution, I'd also like to be pointed in the right direction? Perhaps a brief idea of how you resolved it?

Thanks for any and all help!

CaptureExcel.PNG