Need a MACRO which cleans vertical data in 1 column and transposes it to a new worksheet

[cglobres]

Hi,

Attached is a small sample of the vertical data, which I am trying to "clean" and then transpose into a new worksheet but under respective column headings. (see sheet 2 for the final format the data should be in)

1. If you look at sheet 1, this is the data we have (script should keep going until there is no more data on the sheet).

2. Only certain rows need to be transposed to the new sheet and placed under their respective column headings.

If you look at sheet 1 and sheet 2 I'm sure you will understand the process.

THANK YOU in advance for looking into this.