How to copy a column and paste as row in excel?

Discussion in 'General Chat' started by johnsonp, Oct 31, 2009.

0
  1. #1
    Hi,
    I am finding difficulty to copy entire column and paste as row in MS Excel. Help!
     
    johnsonp, Oct 31, 2009 IP
  2. vinoth2vinoth

    vinoth2vinoth Peon

    Messages:
    691
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    0
    #2
    Which office version you are using?
    Are you getting any error message?
    Is it the first time you are facing such issue?
     
    vinoth2vinoth, Oct 31, 2009 IP
  3. johnsonp

    johnsonp Peon

    Messages:
    1,217
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I am using MS Office 2003. I don't know to to do this?
     
    johnsonp, Oct 31, 2009 IP
  4. vinoth2vinoth

    vinoth2vinoth Peon

    Messages:
    691
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    0
    #4
    vinoth2vinoth, Oct 31, 2009 IP
  5. kumarg

    kumarg Active Member

    Messages:
    1,108
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    78
    #5
    Copy -> Paste Special -> Transpose -> OK

    It works perfectly.
     
    kumarg, Oct 31, 2009 IP