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
2 Trackbacks