Let’s say you have data in Excel that is currently laid out vertically:
1.2
2.3
3.4
5.6
and you want to change it to be laid out horizontally as such:
1.2, 2.3, 3.4, 5.6
You can do so by:
1. Copy (CTRL+C) the original data.
2. Select a cell where you want your new data to be inserted to.
3. Select the edit menu > Paste Special and check the Transpose tickbox. If you fancy shortcut combination keys, you can get there with ALT+E, S, ALT+E.
4. Voila, your new data will be pasted and transposed from vertical to horizontal.
The same steps apply when you are trying to copy data laid out horizontally to be shown vertically.
Advertisements
Mr Moon says
Hi,
How do you copy and paste date from vertical to horizontal but link it so that when you update a cell it changes the corresponding cell in the revised format?
Marcel says
thanks for this
Shammie says
How this is working on Excel 2003?
David says
Not sure what you are trying to ask but have tested this on both Office 2003 and Office 2007, and yes it works.
Shammie says
Thanks for your reply.
When I copied data from a Excel sheet then I can find a form with the Transpose tickbox. If I copied the data from somewhere else (from a Notepad, etc…) then there is a different context form under “Paste Special” menu item.
David says
I get it now. Yup, you are right, copied data from other sources such as Notepad do show a different “Paste Special” menu.
So, can’t you just paste the copied data from, for ex Notepad, into Excel, copy the pasted data in Excel, and then do a paste special > transpose again?
I know it’s a bit repititive but I’m sure that still works 🙂
Shammie says
Yes, I did it. Thanks.
UOCRES says
Thanks a lot. I really helped to save my time a lot.
Manish Bharti says
AWESOME 🙂
shyamu gupta says
thanks very much