Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Rotate a row in Excel

    I don't remember the function that rotats a row in Excel to become a Column?
    I want to move the data from B1:F1 to A2:A7
    Can you help?
    Thanks

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Somebody in the Excel forum might be able to give you a different way to do this, but if it is a one-time procedure, I would use Copy; Paste Special; Transpose, which will do what you've asked for.

    TD

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Hi Hammbakka
    have a look at the transpose function
    HTH

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you, yes that is the Transpose function, I remember now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •