Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: MS excel :- How can i convert columns in rows  (Read 3649 times)

0 Members and 1 Guest are viewing this topic.

shebeershah

  • Guest
MS excel :- How can i convert columns in rows
« on: November 24, 2009, 09:19:52 AM »
Please help me :'( how can i convert data in the column to rows without typing the same
for Eg: in A1=30,B1=32,C1=34        to             D1=30,D2=32,D3=34

mroilfield



    Mentor
  • Thanked: 42
    • Yes
    • Yes
  • Computer: Specs
  • Experience: Experienced
  • OS: Windows 11
Re: MS excel :- How can i convert columns in rows
« Reply #1 on: November 24, 2009, 09:31:23 AM »
Do you want to keep that values in the columns or will you delete them once you have them in rows?
You can't fix Stupid!!!

soybean



    Genius
  • The first soybean ever to learn the computer.
  • Thanked: 469
  • Computer: Specs
  • Experience: Experienced
  • OS: Windows 10
Re: MS excel :- How can i convert columns in rows
« Reply #2 on: November 24, 2009, 11:59:40 AM »
Select A1:C1, Copy, move your cell pointer to D1, right click and select Paste Special.  In the Paste Special dialog panel, put check mark in the box for Transpose and click OK.

Karnac



    Specialist

    Thanked: 211
    Re: MS excel :- How can i convert columns in rows
    « Reply #3 on: November 24, 2009, 01:25:02 PM »
    Nevermind.
    « Last Edit: November 24, 2009, 01:51:04 PM by Karnac »


    Never argue with a stupid person, they'll drag you down to their level and beat you with experience.

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: MS excel :- How can i convert columns in rows
    « Reply #4 on: November 24, 2009, 01:34:33 PM »
    My post has the solution.  Now, if we can have some feedback from shebeershah ...  ::)