One important tool in Excel 2013 that we will be using is the Paste Special utility. Microsoft understands that copying and pasting is not always as simple as moving data, and that sometimes you just want the values from a group of cells and you do not want to paste everything exactly as it was originally copied. So once you have followed the steps below to learn how to paste your horizontal data into a vertical area, you should explore the Paste Special options a bit to see if they can help you.

 

Step 1: Open your spreadsheet in Excel 2013

 

Step 2: Highlight the horizontal data that you want to paste into a vertical location.

select the data

 

Step 3: Right-click the highlighted data, then select Copy.

copy the selected data

 

 

Step 4: Click in the top cell where you want the vertically pasted data to begin.

select the locatio where the data is to be pasted

 

 

Step 5: Click the Home tab at the top of the window.

click the Home tab

 

 

Step 6: Click the Paste drop-down menu in the Clipboard section of the ribbon, then click the Transpose option.

select the transpose option from the paste menu

 

 

Your copied horizontal data will now be displayed vertically. This procedure also works with multiple rows of data at once. Note, however, that it does not work if you use the Cut command. You will need to go back and cut or delete the original data once you have correctly converted it to display vertically.


Link

http://www.solveyourtech.com/how-to-paste-from-horizontal-to-vertical-in-excel-2013/