Forum Discussion
Manchester05
Jan 13, 2021Copper Contributor
Transpose, Tweaking the movement
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 a...
SergeiBaklan
Jan 13, 2021Diamond Contributor
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