How do you change a row from a column in Excel?

You use the TRANSPOSE feature of the PASTE SPECIAL command, having just copied a row of data. You can also use the TRANSPOSE function.