Transpose, Tweaking the movement

[C V Horie]

I have a number of large spreadsheets with series like

R616	cvh0695
R617	cvh0696
R618	cvh0697

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

[#2]

@C V Horie 

For such sample

you may use

=INDEX($B$3:$C$22,INT((COLUMN()-COLUMN($E$3))/2)+1,MOD(COLUMN()-COLUMN($E$3),2)+1)

and drag it to the right