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.