Need To Change Horizontal Table to Vertical List

Hi

I need to change data from a horizontal table into a vertical list, can anybody help? example.xlsx

I searched the formum and found solutions to a similar problem but they don't quite work for this. This isn't one that transposing will fix

Thanks in advance.