PDF--->Excel weird format result. Trying to fix with VBA

So I had succeeded in finally getting the pdf file converted into a semi-workable format. Some data is formatted fine, but other pages are formatted with a bunch of data input into a single cell (40-50 items). I can't get pro without my company first approving it, so I am trying to code a work-around to automate this otherwise mundane tax. New to scripting in Excel, however I did take coding classes in college. I have attached two screenshots, one with the problematic formatting, and the latter with desired formatting. The idea I have now is to have excel find instances of FP and then inserting a line-break before it. But that doesn't result in the data being in its own cell. Anyway to do this? I am reading up to try to figure it out, but if anyone can point me in the right direction, that would be great.

http://imgur.com/a/ln2uA <---- Problem Data

http://imgur.com/a/PKfMM <----- Correct Data

Attached. I'm a little bit at a loss, as There is no real sequence of the part number, nor the naming of each part. Sheet1 is current data, Sheet2 is desired output/formatting. Thank you for any help.

Thanks for looking into it, but I found a work around using text-to-columns and transpose.