VBA Macros code - copy paste transposed loop

  • Currently struggling finding a faster process for sculpting this data:


    Several rows with 4 columns with data, i need to create loop code for transposing data from row (range:colum:D-Empty cell) to columns.

    Example (Dummy data) attached to this thread, The actual data is 200 rows, giving a product of about 4500 rows when data is transformed.


    Thanks in advance for any clue for automating this process, via macros loop or any other suggestion power BI is not an option since i work with Macos.

  • Create a sheet named "Result" that has the following headers in row 1 starting in column A:

    Car Country Brand Spare Parts

    Try this macro:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!