Create a daily work schedule

Imagine a 4 column dataset as shown below:

Resource Name	Start	End	Projects
Raghav	02-06-2015	05-06-2015	p4
Raghav	02-06-2015	07-06-2015	p5
Raghav	08-06-2015	12-06-2015	p1
Raghav	16-06-2015	19-06-2015	p2
Raghav	22-06-2015	26-06-2015	p3
Ashish	03-06-2015	09-06-2015	p6
Ashish	04-06-2015	07-06-2015	p7

One may want to transform this dataset to the below mentioned one.  There will obviously be a lot more columns to the right (I’m only showing a snip)

Employee Name	01-06-2015	02-06-2015	03-06-2015	04-06-2015	05-06-2015
Raghav		p4 & P5	p4 & P5	p4 & P5	p4 & P5
Ashish			p6	p6 & P7	p6 & P7

I have solved this problem with the help of Microsoft Power Query. You may download my solution workbook from here.

You may watch a short video of my solution at this link