Help Needed for a Macro to Transpose

[Valvictor]

Hello,
I need help with a macro that transposes the information from tab “details” into another tab call “results”. I need in the tab results to Create as many rows per Activity (1-14) as the numbers in the table details in this case 6 columns numbers. These are 4 digits numbers such 2423 in the picture attached (Details Tab) below. This could vary depending on the situation. Then transpose corresponding numbers, durations, costs, and start and end dates from the details tab picture attached below:

The macro will output the “results” tab with columns: Activity, Numbers, Duration, Cost, Start date, End Date, and Type. The Type column will output a “text”, which is the same for all activities. Each row activity will have the corresponding start and end date described in the details tab repeated as many times as the numbers. Picture attached for the results tab and the details tab containing the information to transpose.

Thank you for your help,
Val

 

[alansidman]

1. Your pictures are to small to determine what is happening. Cannot read them.
2. We cannot manipulate data in pictures
3. Please reload your sample data to this forum using XL2BB
4. See this link on how to use XL2BB XL2BB - Excel Range to BBCode

 

[Valvictor]

Hello,
I need help with a macro that transposes the information from tab “details” into another tab call “results”. I need in the tab results to Create as many rows per Activity (1-14) as the numbers in the table details in this case 6 columns numbers. These are 4 digits numbers such 2423 in the picture attached (Details Tab) below. This could vary depending on the situation. Then transpose corresponding numbers, durations, costs, and start and end dates from the details tab picture attached below:

The macro will output the “results” tab with columns: Activity, Numbers, Duration, Cost, Start date, End Date, and Type. The Type column will output a “text”, which is the same for all activities. Each row activity will have the corresponding start and end date described in the details tab repeated as many times as the numbers. Picture attached for the results tab and the details tab containing the information to transpose.

Thank you for your help,
Val

Hello, this is the detail tab containing the information to transpose into the Results tab

The "Results" tab will be :

 

[alansidman]

Still cannot manipulate data in a picture. Since you have not loaded via XL2BB, I am not going to demonstrate, but will suggest you use Power Query to Unpivot your data.

 

[Valvictor]

Hello, this is the detail tab containing the information to transpose into the Results tab

View attachment 107917

The "Results" tab will be :

View attachment 107919

 

[Valvictor]

I am sorry. I saw other examples in the forum, and they all look like this.

 

[alansidman]

That may be true, but I probably did not respond to those either. Good Luck. Maybe someone else will come by and be willing to deal with pictures.