Recreate raw data into a legible table using formulas

[john dalton]

Hi, I have some raw data which needs re-creating in a table to match the way it was originally intended to be viewed. I have a problem in that there are (supposed) blank cells that are making the data re-alignment very difficult I have tried several solutions but nothing seems to works.

Please see attached spreadsheet with stages of how I have tried to re-create the table and the desired outcome (highlighted in yellow)

Many thanks in advance for any suggestions and help.

John