I am looking for a way to create a report like this:
Map mon to = start_date
Map tue to = start_date +1
Map wed to = start_date +2
Table:
+---------+------------+-----+-----+-----+------+-----+-----+-----+------------+-----------+
| Empl_ID | Project ID | mon | tue | wed | thur | fri | sat | sun | start_date | end_date |
+---------+------------+-----+-----+-----+------+-----+-----+-----+------------+-----------+
| 95 | Admin | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 4/24/2017 | 4/30/2017 |
| 95 | BH | 3 | 3 | 3 | 3 | 3 | 0 | 0 | 4/24/2017 | 4/30/2017 |
| 95 | Fiber | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 4/24/2017 | 4/30/2017 |
| 95 | E-Rate | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 4/24/2017 | 4/30/2017 |
| 111 | E-Rate | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 4/24/2017 | 4/30/2017 |
| 111 | Admin | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 4/24/2017 | 4/30/2017 |
+---------+------------+-----+-----+-----+------+-----+-----+-----+------------+-----------+
Desired Output:
+---------+-----+--------+----+
| 4/24/17 | 95 | Admin | 2 |
| 4/24/17 | 95 | BH | 3 |
| 4/25/17 | 95 | Admin | 2 |
+---------+-----+--------+----+