Push data to new table

Registration date
Monday April 27, 2015
Last seen
April 27, 2015
Hello Everybody!

I am trying to build a tool for our Company which helps plan future collection and eventually should turn into a Gantt.

So... i have a table, each row represent - Collection name / Category / Sub Category / Plain data / Designer / and this is the tricky part - Dates for each step of events.
so i have about 14 columns with different events, and for each collection we are adding dates.

2 part question -
1. Should I / How do i copy the data automatically into a new data table, that will create a row for each Task / Event for each collection / Sub Category?

2. How do i push the data into Gantt / Calendar to show each Designer her tasks?

Would be happy to get some help with the first issue at least :)

Thank you!