Data Modeling help

[AdarshRaj]

I have 50 trucks data in a excel , one row per truck. I have multiple columns for their parts along with their order date and delivery date.  So suppose i have 3 parts per truck then there will be 6 date columns. every part has a order and delivery date.

How do i show this data into a gantt chart. that there would be each truck as parent and parts as child and i would have the date shown in the gantt chart.

[lbendlin · Accepted solution]

You would unpivot your data so you are left with four columns

Truck - part - order date - delivery date

Then you can feed this much easier into your chart.