transpose matrix in one column?

I will play with your code for learning purposes, thanks :D
..However, here is my sample, if you would be so kind to adapt the code to it
(by the way, the result should be put in a new sheet, next to the original)