Create Gantt Chart with Month/Date Columns

I need some help creating a gantt chart showing months an individual is working a given project throughout the year. The data is formatted such that the dates used for start and stop of a Product are captured under a column for the given month, and projected hours for that month are in the cell coincident with the product and employee working it.

My primary question is how to format the data in a manner that would facilitate using a Excel Gantt template? I think the start/stop dates would need to be in the rows themselves. I need to create an automated method for reformatting the data to populate a gantt chart visual. I have played with using =SORT(CHOOSECOLS(UNIQUE(FILTER( to reformat but have been unsuccessful.

TestGantt.xlsx

d9242713-0d01-47f8-b499-dbb10f230698.png

Rule 7: Cross-posting Without Telling Us

Your post does not comply with Rule 7 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.

crossposts: https://www.mrexcel.com/board/thread...lumns.1273270/
https://answers.microsoft.com/en-us/...1-6a9d5cde17d4

Not sure how the requested Gantt chart should look which makes it hard for us (and apparently contributors on other sites) to help in formatting the data.
Here is a guess that perhaps will be a starting point.
1. Populate cell A2 using:

Formula:

Please Login or Register  to view this content.

2. Populate cell AV1 using:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.