For beginners, often we are stucked at some tasks that are easy in the eyes of more experience users.
Here is a great example:
Copy from A2 to A13 and Paste horizontally from C2 onwards.
 |
| Excel Copy Paste Horizontally |
If you want to copy a range vertically and paste it horizontally in Excel, this is what you can do:
- Select Cells A2 to A13 and press copy.
- Go to cells C2 and right click.
- Under the many paste options, select Transpose (the 4th shape) and you are done
