Oct 28 2019 04:38 AM
Fill in gap between dates in a table
I have table with several dates in a column and numbers in another. I want to fill the gap between the missing days using weekdays only, and repeat the number on each of the dates already available in the date column. How do I do this? Thanks
Here is the table to fill
Date | Value |
6/30/1980 | 1 |
12/12/1980 | 0 |
12/26/1980 | 1 |
1/8/1981 | 0 |
2/9/1981 | 1 |
6/22/1981 | 0 |
Nov 09 2019 12:52 PM
As variant you may add another 'calendar' column from minimum date to maximum or newer (e.g. by autofill) and another column for values as here