Use the past special operation: "Transpose" in Microsoft Excel 2010 to convert column values to row values:

Select column values and press CTRL + C:

image

 

Select a cell outside the range, in this example I selected B1.

Home > Paste special > Transpose

image

 

Result:

image

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.