Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Thanked 0 Times in 0 Posts

    'transpose' in Excel

    Am trying to move 218 rows and 15 columns 90degrees to make 218 columns and 15 rows for easier downloading of data in the future to SPSS.
    The transpose function should do this, correct?
    Have tried it, and the whole program defaults when I attempt to copy it to another spreadsheet in the Excel document.
    Do I have to go cell by cell?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Re: 'transpose' in Excel

    There are 2 ways to do this:
    If your data is in Sheet1!A1:O218 and you want to transpose it into cells Sheet2!A1:HJ15

    Method 1: Use the TRANSPOSE function
    Select range Sheet2!A1:HJ15 and enter the following formula
    This needs to be entered as an array formula (press Control+Shift+Enter and not just Enter)

    Method2: Use paste special
    Select range Sheet1!A1:O218 and copy it to the clipboard
    Go to Sheet2!A1 and select "Edit>Paste Special" and select the transpose option

Posting Permissions

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