vba code to transpose vertically

Hi! I don't have much time to browse through the posts that might be able to help me, so I'm posting a file similar to the one I'm working with.

I'd like to get help with working out with a vba code that'll be able to transpose data vertically.