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.

Hi, try it

Please Login or Register  to view this content.

works magic! thank you!