I have a table with several columns. The first is a name and the second is a date. For each name there are several dates. The dates should be sequential. If there is a gap of one or more days, I would like to add a line with the name and the missing date.
<tbody>
</tbody>
david | 3/5/19 |
david | 3/6/19 |
david | 3/8/19 |
david | 3/9/19 |
John | 3/11/19 |
John | 3/15/19 |
John | 3/16/19 |
<tbody>
</tbody>