Posts by RoadFW

    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.