Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: Turn row into column

    I know I should know this, but how do I turn a row of values into a column of values?

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by jrn0074
    I know I should know this, but how do I turn a row of values into a column of values?
    Select and copy the cells in the row. Select the next blank cell below the copied row or select a new blank worksheet. Select 'Edit->Paste Special...' On the displayed dialog check "Transpose" then click OK.

    If you have the Multi-Paste button showing in Excel 2003 (The Paste button combined with a drop arrow) you can click that drop arrow to use the transpose paste option directly from the toolbar button.
    ~

    Bill

Posting Permissions

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