I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular month's value mentioned for every day of the month. I tried using `VLOOKUP()` but was unsuccessful.

A screenshot of the data sheet can be seen below.

[![data sheet](https://i.stack.imgur.com/GLoDs.jpg)](https://i.stack.imgur.com/GLoDs.jpg)