'Excel transpose array into single column

I am trying to transpose the following array into a single column. Can anyone please help?

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source