Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Switching Columns to rows (Excel 2000)

    How can I switch my columns to rows and vice versa without damanging the integrity of the sales data? I need the data to move with the specific ABC/DEF combinations. See attachment

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switching Columns to rows (Excel 2000)

    Select A1:CS39.
    Copy to the clipboard.
    Activate (for example) Sheet2, or a cell on Sheet1 outside the selected range.
    Select Edit | Paste Special.
    Tick the Transpose check box.
    Click OK.

Posting Permissions

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