Question: how to copy and paste on excel from columns to rows?
Answer: Select the range of data you want to rearrange, including any row or column labels, and either select Copy. ... 
Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.