Data Layout

Thanks for the reply. Will that work for the example of data I have attached though? (apologies the example is using google sheets as my home laptop doesn't have office currently, the actual data is in Excel 2010). The top is how it is formatted now and the bottom is how i need it formatted ideally.

Thanks.