September 7, 2012

EXCEL 2010 : Changing data from horizontal cells to vertical cells and vice-versa.

How to change data data from horizontal cells to vertical cells and vice-versa?

Example :-

1.12
1.13
2.14
2.15
to
1.12  1.13  2.14  2.15

Solution:-

-Copy your data using Ctrl+C.
-Choose the cell where you want to paste your data.
-Go to the Edit Menu and choose "Paste Special".


-In the paste special dialog box choose "All" and click the "Transpose" option and then click Ok.

No comments :