Copy Paste Row To Col Wtout Transpose. The next thing is we need to decide where we are going to paste the data. Sub demo dim rng as range dim src as variant dim dst as variant dim groupsize as long dim groups as long dim irow as long dim icol as long dim idst as long dim srcstartrow as long dim srccolumn as long dim dststartrow as long dim dstcolumn as long set up parameters groupsize 2.
There s a really easy fix in the paste special menu that allows you to reverse your mistakes and columns to rows without starting over. Then press ctrl c to copy the selected cells and select a cell to right click to open the context menu and click paste special transpose to paste the cells in transposition. Sub transpose example2 range a1 b5 copy end sub.
Right click a blank cell you want to paste the data in and select paste special paste special from the.
Once you get dynamic arrays writing the transpose function becomes super simple. Data in rows is pasted into columns and vice versa. Transpose reorients the content of copied cells when pasting. On the home tab click the paste icon and select paste transpose.
