Hi! I have a dataset in the following format: ID Value Created_date Updated_date 1 49 12-1-2020 12-1-2020 1 49 12-1-2020 1-1-2021 1 112 12-1-2020 2-1-2021 1 230 12-1-2020 4-1-2021 1 506 12-1-2020 6-1-2021 2 10 4-1-2020 4-1-2020 2 64 4-1-2020 7-1-2020 2 89 4-1-2020 8-1-2020 2 29 4-1-2020 10-1-2020 .... I would like to insert rows for the missing months in the updated_date column with the values from the previous non-missing row. It would look like this: ID Value Created_date Updated_date 1 49 12-1-2020 12-1-2020 1 49 12-1-2020 1-1-2021 1 112 12-1-2020 2-1-2021 1 112 12-1-2020 3-1-2021 1 230 12-1-2020 4-1-2021 1 230 12-1-2020 5-1-2021 1 506 12-1-2020 6-1-2021 2 10 4-1-2020 4-1-2020 2 10 4-1-2020 5-1-2020 2 10 4-1-2020 6-1-2020 2 64 4-1-2020 7-1-2020 2 89 4-1-2020 8-1-2020 2 89 4-1-2020 9-1-2020 2 29 4-1-2020 10-1-2020 .... I used a do loop to come up with something close to my desired result but not exactly what I am looking for. Any ideas? Thanks!
... View more