Issues with a PDF saved as Excel and then formatting that data

Hello,

My name is Ebony and I am trying to format data exported to/saved as excel from a pdf. The issue is, once I save the pdf as excel and open the excel spreadsheet, the data is jumbled and has no pattern for me to be able to format for example with text to columns. Someone here at my job that is no longer with us somehow did it in the past but I have no idea how. Attached is an excerpt from the pdf, the data once saved as excel from that same pdf and a spreadsheet that is an example of what I am trying to have the end product resemble. Any help is greatly appreciated. Please advise.

Many Thanks