VBA Code for copying from row to column

  • Hi There,

    I am very new to VBA macro coding, and encounter a spreadsheet in workplace that need help.

    We have a spreadsheet like below now:


    and what we try to achieve is below:


    so we want to move the information that within the same company in rows to columns.


    appreciate your help!!!


    Thanks!!

  • Hello and Welcome to the Forum :)


    Best thing to do is to attach a sample file ... most probably, a simple formula can handle your request ...;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • royUK

    Changed the title of the thread from “VBA Code for coping from row to column” to “VBA Code for copying from row to column”.
  • To switch to a different layout, see attached your test file ... without any macro ...;)


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Surprisingly enough ... more than a week after your initial question ... still no feedback ...=O

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)