I have an Excel document where we track team projects' travel periods.
Users are ordered in 1st column. Bellow is Projects coloring legend.
Team members are on site like User1, 20.11.2016. - 11.12.2016.
My question is, Is something similar possible to achieve in SharePoint?
List with Gantt view came up my mind, but I don't know how to achieve to have every travel of user in same item. I would have to add new columns every time user goes to site the other way I know is to edit item and remove current dates and put new data, which I don't want to do. Also Excel sheet preview in web part is not an option.