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

Hi Ebony,

I have tried doing what you are asking many times in the past. Have always found that once something has been converted into a PDF the formatting is totally out of wack.
I have gone so far as to ask the source to provide that data in a spreadsheet or even CSV file.

If you have access to the info online via web page, it is easier to capture and apply to a spreadsheet.

If none of those are an option, I go manual entry.
If the PDF is in text format you can capture the data manually one column at a time.
With the cursor near the top left of a column of choice, hold down the ALT key and drag down and to the right to highlight a column. Copy and paste.

There are probably a few Guru's out there that have a better solution. But that has been my experience trying to convert PDF's to spreadsheet.

Good luck.
Cheers,