Transpose, Tweaking the movement

Occasional Contributor

I have a number of large spreadsheets with series like

R616cvh0695
R617cvh0696
R618cvh0697

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

1 Reply

@C V Horie 

For such sample

image.png

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