Need help organising data

Hello all,

Not sure if this is in the correct part of the forum but here goes.

I am in dire need of some expert assistance as my limited knowledge of Excel has my completely stumped.

I have attached a small spreadsheet (just a snippet of the amount of data i actually have to process) that demonstrates the current format and required format.

There are approx 175k rows of data although this will be smaller when the job is actually run as I need to remove some erroneous data.

If anyone can help me in trying to organize my data I would be hugely grateful.

many thanks

Arvon