Hi everyone,

im looking for a way to transpose my data for formatting into a Gantt chart, using VBA.

The original worksheet has a bit of data in columns A to I, and a few dates (for different milestones of the workload) in J:P

Now I want each date to go in a serperate row, while also copying the data from A:I, and also specifying the date type by coping the header along into a seperate column. I have put a "before" and "after" worksheet in attachments (worksheets 1&2)

I have tried various approaches regarding range transformations, yet to no avail.

the cells in blue need to automatically transcribe to the cells in blue on the second worksheet.

Please help!

regards,

Sok

Attached Files

tester(datetransformation).xlsx (11.7 KB, 11 views)