Move column to Row using Macro

Hi, I have a problem, I want to automate some layout in my excel sheet using macro. Please find attached image: https://ibb.co/nPOkBR (source)
So that is the source. And what the result that I want is as follow : https://ibb.co/eJMBkm (expected result)

The logic is:
1. the last column is column G
2. If the active column exceeding column G, then It would be moved into the row below the last row.
3. the column A (Name) will be repeated for each new movement.
4. If after move the column into new row and the active column still exceeding the column G, then it would be moved again to the next row below until the last active column doesn’t exceed column G.

Please forgive for bad explanation. You will understand if you see the source image and the expected result.
Please share the idea how to do this using macro! You will help me a lot!

By: Raspi

4 thoughts on “Move column to Row using Macro

  1. ig

    For newest information you have to pay a quick visit
    world wide web and on web I found this web site as a most excellent web page for
    most up-to-date updates.

Comments are closed.