Insert new rows for missing dates

Sort of a beginner to Alteryx, so, don't know if there is an easy solution.

My original input file has 1000s of rows, 20 columns with data and last column is a date field.

If there is a missing date, I want to create new rows and copy the values from the previous date and add the new date.

As per the attached sample file (2 tabs), input file is missing data for 24/10/2020 & 25/10/2020.

Required output should

1. Insert data from 23/10/2020 and add date as 24/10/2020.

2. Insert data from 24/10/2020 and add date as 25/10/2020.

Hoping someone can help.

Thanks!

Input

Preparation

Accepted answers

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Thanks atcodedog05,

I was able to apply your workflow to mine and it worked. Got the output that I was after.

Thanks for the prompt response!