I want to go through a list of dates, and insert new rows with the dates that are missing. For example, from a column of these dates:
[TABLE="width: 123"]
<tbody>[TR]
[TD="align: right"]3/6/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/6/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/17/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/18/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/19/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/21/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/23/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/23/2015[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
I want to insert dates 3/7-3/15 and 3/22 (one row for each date) in new rows with the same name taken from a first column of data. Does anyone know how to do this in a automated way such that for every day that is missing from the original list of names and dates, then a new row will be inserted taking the same name.
[TABLE="width: 123"]
<tbody>[TR]
[TD="align: right"]3/6/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/6/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/17/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/18/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/19/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/21/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/23/2015[/TD]
[/TR]
[TR]
[TD="align: right"]3/23/2015[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
I want to insert dates 3/7-3/15 and 3/22 (one row for each date) in new rows with the same name taken from a first column of data. Does anyone know how to do this in a automated way such that for every day that is missing from the original list of names and dates, then a new row will be inserted taking the same name.