Copy Paste Row To Col Wtout Transpose. Copy the cell range. Use a simple formula trick to transpose.
Right click a blank cell you want to paste the data in and select paste special paste special from the. Sub transpose example2 range a1 b5 copy range d1. You re going to transpose everything.
Select the range you want to transpose when paste and then press ctrl c keys simultaneously to copy the selected.
This way you can transpose without an array formula and also transpose without copying and pasting. You re going to transpose everything. Data in rows is pasted into columns and vice versa. Select the range you want to transpose when paste and then press ctrl c keys simultaneously to copy the selected.
