Merge randomised row data

[Stev_data]

Hi,

I have an output from a database which is random with poorly aligned columns and row data. I want to align it into ordered form as shown in link

Current

Expected Result 

Here is the link showing the raw data as against the final desired result

https://docs.google.com/spreadsheets/d/e/2PACX-1vQl4__7u-xSYUuEPMYFjED7jMVeqYTdVNiaHeNY7UyaYrBOBs7Ic... 

[AlexisOlson]

This is likely possible but, given the input data, there isn't going to be a short answer or single technique that will solve this. In other words, this is more of a small project than a single question.