Help filling in missing dates

[jacspear]

Hi, I have a list of stock prices for a stock via download from public source. The data doesn't have rows for weekends or market holidays. I am having trouble finding an example of how to fill in the missing dates with the closing price as the most recent prior closing price. The dates on the file will change each time we update the stock price file. I only care about the date and closing price on attachment.

Any help is appreciated. Thank you!

[Qiu · Accepted solution]

@jacspear 
We can calculate the Day Diff between two adjcent dates then add more rows with Geneate Rows tool/

[jacspear]

The solution you provided worked perfectly. Thank you for such a quick response!

[Qiu]

@jacspear 
Glad to be helpful.