Question: how to copy and paste in excel from vertical to horizontal?
Answer: Copy the vertical data. ... 
Find the cell you want to insert the data, and then click on it to select.
Select the Paste button, but click on the down arrow – and a pop up menu of choices appears (these are your Paste Special options). ... 
Select the Transpose option and click ok…and your vertical data is now across the top row.