I am looking to get the daily rate of individuals given a time range in two columns.

| Start Date | End Date | Daily Rate | Entity |
| --- | --- | --- | --- |
| 07/23 | 08/06 | 212 | A |
| 07/23 | 08/06 | 175 | B |
| 07/23 | 08/06 | 202 | C |
| 07/23 | 08/06 | 301 | D |
| 07/23 | 08/06 | 215 | E |

For all dates in this range I want a row that will repeat each entity's daily rate. Like below but this trend will continue on entity A until it hits 08/06 and then move onto entity B.

| Start Date | End Date | Daily Rate | Entity | Date |
| --- | --- | --- | --- | --- |
| 07/23 | 08/06 | 212 | A | 07/23 |
| 07/23 | 08/06 | 212 | A | 07/24 |
| 07/23 | 08/06 | 212 | A | 07/25 |
| 07/23 | 08/06 | 212 | A | 07/26 |
| 07/23 | 08/06 | 212 | A | 07/27 |
| ... | ... | ... | ... | ... |
| 07/23 | 08/06 | 212 | A | 08/06 |
| 07/23 | 08/06 | 175 | B | 07/23 |
| 07/23 | 08/06 | 175 | B | 07/24 |
| ... | ... | ... | ... | ... |

I also need this to work for any date range, not just this one date range.