How to copy paste Vertical values horizontally in Excel and vice versa

Shortcut Excel copy paste values horizontal to vertical and vice versa!!!

Many a times while preparing MIS in Excel we need to copy / /cut paste the values or text from horizontal to vertical or we might also say from rows to column or vice versa.


Here is the best shortcut for the same using paste special function with checking checkbox transpose. In Excel language transpose is used as log game to copy paste values from one dimension to another, but please make sure that copy and paste area doesn't overlap otherwise the function wont work!!

Example: Say suppose we want to convert this table from vertical to horizontal format or we might say from columns to rows

Now, here we need to select the entire table and copy the same ,thereafter need to select/ click on a cell where we want to transpose the values / text  which should not be overlapping to already selected cells.Use value paste function Shortcut: ALT + E + S and the window that opens looks something like this and checkbox values and transpose, Shortcut: V + E (Rem no Alt this time as we are already in Alt function)

Now its time to press ok / Enter and the result that we will get would look like this

Yup we are done there!!

Please note the same hold true for single row or column as well!!



Happy Reading!!!