Hi excel and macro gurus,

Please help me. I have PDFs/HTML files with records which I will like to pull out and put into rows in excel file for easy sorting. I am terrible with excel and know nothing about macro, and if anyone can help me out, i will be so grateful.

The data I have runs like these, but with much more records (this eg is only 2 records):

ScreenHunter_56.jpg

I want to extract them to an excel file which sorts them to these corresponding to their values:

ScreenHunter_57.jpg

How do I do them? Please keep in mind I am terrible with excel and have no experience in macro when you guide me. Thanks!