Reassemble cells to new layout

Hi everyone,

I have an existing excel workbook with raw data, which I need to convert into another layout.

In the attached template you see the raw data. It shows all periods in which a staff member is off work.

This raw data I want to format the following way:

Instead of having every leave on a separate row I would like to have every day of 2016 as the top row (basically the x-axis) and the names (in total about 30 names) on the y-axis. And then have an x or a color formatting in for those cells where a staff member is off work.
One difficulty is also, to convert a period like in row 24 to that new format.

How can I best convert this raw data to the desired format?

In advance, thousand thanks for your help!

EDIT:

I have also added a file which shows how the final layout should look like.