Transpose, Tweaking the movement

I have a number of large spreadsheets with series like

I want to transpose these to (interestingly, I cannot even copy from my spreadsheet to achieve that here)

R616    cvh0695   R617  cvh0696   R618  cvh0697

Is there a method to achieve this?

Thank you