Excel convert row to column tutorial

This is a step by step tutorial on how to convert Excel rows to columns. There are a couple of ways for doing this, both equally easy.

One way to move rows to columns is to use the transpose function, which copies data from columns to rows and vice versa. The other way is to copy & paste with transpose option.

Transpose function

1. Select the cells where you want to move the data and click on the fx button under the Ribbon.

Excel Convert columns to rows with transpose function

2. Write "transpose" to the search field and click go. Select the transpose function from the search results list by double clicking it.

Excel Convert columns to rows with transpose function

3. Drag select the cells that contain the data and press ctrl + shift + enter simultaneously to convert.

Excel Convert columns to rows with transpose function

4. The outcome.

Excel Convert columns to rows with transpose function

The Copy & Paste method

  1. Select the cells that contain the data.
  2. Right click on the cell you wish to be the top left corner of the table.
  3. Choose transpose from paste special options.

Excel Convert columns to rows with paste special
 

3 comments:

  1. Excellent and decent post. I found this much informative, as to what I was exactly searching for. Thanks for such post and keep it up.

    Arianne
    www.gofastek.com

    ReplyDelete
  2. I do believe that beauty is in the eye of the beholder. What does it really means to us? It only explains that true beauty is not in our physical aspects but in our inner aspects. In short, attitude or character because what you have shown is what people think of you. Beauty comes out naturally. Visit my site #triciajoy for some terrific offer that I am sure you can't refuse. Thanks for sharing such a wonderful article. Have a good day!

    triciajoy.com

    www.triciajoy.com

    ReplyDelete
  3. Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.


    ufgop.org
    ufgop.org

    ReplyDelete