Code/Formula to sort large amounts of data

Hello,

I have done something similar in the past, where I would paste a large amount of data into a spreadsheet and then using coding and/or a formula to sort the data into a more organised way etc. However, I am unsure how to do it and what is the best way to do it?

A sample spreadsheet is attached.

Any help is much appreciated.

Many thanks as always.