Copying Column Range to Row Range

  • Re: Copying Column Range to Row Range


    Quote from teoant

    I ame trying to copy a column Range to a Row range at once
    any help Please



    Highlight the data that you want (A10 -A17 in your example) & copy (ctrl c or edit/copy)
    Select the start location (c1 in your example) and then use edit/paste special and check the "Transpose" box and click OK

  • Re: Copying Column Range to Row Range


    Quote from JF

    Highlight the data that you want (A10 -A17 in your example) & copy (ctrl c or edit/copy)
    Select the start location (c1 in your example) and then use edit/paste special and check the "Transpose" box and click OK



    Thankyou very much