Question: how to copy and paste rows to columns in excel 2010?
Answer: Copy the cell range. Select the empty cells where you want to paste the transposed data. On the Home tab, click the Paste icon, and select Paste Transpose.