Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

This blog is part of 1 Tute Sets.

Google Spreadsheet and Excel Tutorials
Tute set by sachin.joshi
10 Blogs
prev 1 2 next

  • How to move data from column to row and vice versa in excel- Transpose

    @sachin.joshi
    Recommendations Offline Message

    • 1
    • 3
    • 3
    • 1
    • 0
    • 0
    • 0
    • 0
    • 1.40k
    Comment on it

    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

    alt text

    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:

    alt text

    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-
    alt text


    For MS Excel users-
    alt text

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

    alt text

    open office calc transpose data in ms excel excel tips
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: