How to paste Horizontal Data Vertically in Excel?

1.  Open Excel and copy vertical rows. 
2.  Select where you'd like to paste the data. 
3. Right-click and find "Paste Special"
4. Choose "Transpose" and click "OK"