Transpose after 'trigger' word is met, varying numbers of rows

[jeremyr863]

I am trying to transpose data after the trigger word 'SKIP' is read.
Sheet 1 contains the raw data
Sheet 2 contains how i'd prefer the data output.

Here is the data

Thanks.

 

[Fluff]

Duplicate to: Transpose after certain word

Please stop posting the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.