Convert excel table into one column

Please, can someone help me to save a couple of hours work?! This is an easy example of a more complex task I have to perform.

The table I have to use is not in a logical order as this one. I don't want to lose hours on copying and pasting, but how?

Kindest regards

- - , .
.