Question: how to copy and paste in excel from horizontal to vertical?
Answer: Select all the rows or columns that you want to transpose. ... 
Click on a cell in an unused area of your worksheet. ... 
Click on the arrow below the "Paste" item and select "Transpose." Excel pastes in your copied rows as columns or your copied columns as rows.