Use the past special operation: "Transpose" in Microsoft Excel 2010 to convert column values to row values:
Select column values and press CTRL + C:
Select a cell outside the range, in this example I selected B1.
Home > Paste special > Transpose
Result:
