• Excel macro to transpose rows and columns (Excel 2003)

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Excel macro to transpose rows and columns (Excel 2003)

    • This topic has 2 replies, 2 voices, and was last updated 20 years ago.
    Author
    Topic
    #419084

    I have data in A1:D3 that i need a macro to transpose the rows and the columns.

    The attached in A17:C20 is the result i need when the macro is done. Can someone help me. Thank you

    Viewing 0 reply threads
    Author
    Replies
    • #945189

      Try this:

      Sub TransposeCopy()
      Range(“A1:D3”).Copy
      Range(“A17”).PasteSpecial Transpose:=True
      Application.CutCopyMode = False
      End Sub

    Viewing 0 reply threads
    Reply To: Excel macro to transpose rows and columns (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: