I have a worksheet containing data in rows and columns and I want it change or rotate the data of row to column and vice-versa, for that I have to use feature named Transpose.

Lets learn this from example

As in below image my data in Column and rows are listed like this

I can rotate the the columns and rows to s.no's along the top and Name and Technology along the side. as shown below:

Below is the Process to apply Transpose

1. Select the data you want to Transpose/rearrange including all the rows and column and press ctrl+c (copy). make sure not to cut (ctrl+x) the data.

2. Right-click on the cell where you want to paste the data and select Transpose or if your are using open office calc or libreoffice then select Paste Special, also you can do the same by visiting edit menu from top, see the screenshot below.

For Open office cal user-

For MS Excel users-

3. After clicking on paste special you will find the popup on your screen in that select Transpose and it's done.