help moving poorly structured data to new tab

i have hundreds of thousands of rows of poorly structured data that i'd like to clean up a in a new tab. I have no idea where to start with cleaning this up a bit in a new tab, though I'm hopeful that VBA can get me there. I'd like some help getting my down the right path with this. An excerpt of my file is attached.

As i mentioned the data is very poorly laid out so i've color coded the necessary field labels and their matching data points and have included in the second tab a sample of how i'd like the data organized.

Please help point me in the right direction. And note, I'm completely new to VBA and to programming in general.

Thank you in advance.