I have hundreds of products that I am trying to track the monthly price for. I currently have all the prices of these products but only for specific dates. What I need to do is fill in all the dates in between the existing dates by month up until the present (Dec. 2022).
For example, I have the following products and pricing:
I want to fill in the in-between dates of these products monthly with the first date of the month up until the present date (December 1st, 2022). When the price changes for the product, I want the monthly pattern to still be followed. It should look like this:
Any help is appreciated!
For example, I have the following products and pricing:
Product 1 | 2/15/2022 | $1 |
Product 1 | 6/30/2022 | $2 |
Product 2 | 5/5/2022 | $5 |
Product 2 | 7/27/2022 | $5.50 |
Product 3 | 6/11/2022 | $4 |
I want to fill in the in-between dates of these products monthly with the first date of the month up until the present date (December 1st, 2022). When the price changes for the product, I want the monthly pattern to still be followed. It should look like this:
Product 1 | 2/15/2022 | $1 |
Product 1 | 3/1/2022 | $1 |
Product 1 | 4/1/2022 | $1 |
Product 1 | 5/1/2022 | $1 |
Product 1 | 6/1/2022 | $1 |
Product 1 | 6/30/2022 | $2 |
Product 1 | 7/1/2022 | $2 |
Product 1 | 8/1/2022 | $2 |
Product 1 | 9/1/2022 | $2 |
Product 1 | 10/1/2022 | $2 |
Product 1 | 11/1/2022 | $2 |
Product 1 | 12/1/2022 | $2 |
Product 2 | 5/5/2022 | $5 |
Product 2 | 6/1/2022 | $5 |
Product 2 | 7/1/2022 | $5 |
Product 2 | 7/27/2022 | $5.50 |
Product 2 | 8/1/2022 | $5.50 |
Product 2 | 9/1/2022 | $5.50 |
Product 2 | 10/1/2022 | $5.50 |
Product 2 | 11/1/2022 | $5.50 |
Product 2 | 12/1/2022 | $5.50 |
Product 3 | 6/11/2022 | $4 |
Product 3 | 7/1/2022 | $4 |
Product 3 | 8/1/2022 | $4 |
Product 3 | 9/1/2022 | $4 |
Product 3 | 10/1/2022 | $4 |
Product 3 | 11/1/2022 | $4 |
Product 3 | 12/1/2022 | $4 |
Any help is appreciated!
| | |
| |