Need help with modifying VBA to reference columns (vs. cell values)

Experts:

In another post, expert oeldere provided significant assistance with generating some VBA which allows me to transpose data from one tab into another tab (different structure though).

At this time, I'd like to see if someone could assist me in modifying the code to make it dynamic based on column counts (vs. cell values). As they say, "a picture is worth a 1000 words". Therefore, please find attached XLSM where I provided much more details on tab "MasterData".

Again, expert oeldere really helped me setting up a great process in support of pivot tables and pivot graphs. In order for me to fully utilize the process, tweaking the VBA is required. I'd welcome anyone taking a stab at this challenge.

Thank you,
Tom