Sibeesh Passion

Transpose Row Values To Column In Excel



In this article, we will see how we can transpose or change row values to column in EXCEL. I hope you will like it.


Today when I was just analysing my grid data in office, I just copied some of the conditions in the grid, Since all of the values were in row, it was not pretty much readable. So I thought of changing the values to the columns. And I did. Hereby I am that with you all.

How to do it?

Before going to see how we can do that, please have a look at the data which I have before I transpose.

Please download the transpose.xlsx for viewing the data in excel.

Now what I need is to change those values to column. Right? For that you need to follow the below mentioned steps.

Step 1

Copy the entire data ( Select the row and click ctrl+c)

Step 2

Now click on a cell where you need those data to be pasted.

Step 3

Now Right click on the cell and click Paste Special and click Transpose.

Step 4

Now that is all, we have done it. Now you will see your excel as below.


I hope someone found this article useful. Please share me your valuable thoughts and comments. Your feedback is always welcomed.

Thanks in advance. Happy coding!

Kindest Regards
Sibeesh Venu

Footer With Address And Phones