Generating Rows for missing Saturdays and Sundays

[Deano478]

Hi all,

I've been trying for a while to generate some rows for missing Saturdays and Sundays in my dataset with no luck essentially I have dates like so:

Input:

Leave Date	Day
05/02/2024	Monday
06/02/2024	Tuesday
07/02/2024	Wednesday
08/02/2024	Thursday
09/02/2024	Friday
12/02/2024	Monday
13/02/2024	Tuesday
14/02/2024	Wednesday
15/02/2024	Thursday
16/02/2024	Friday

And I need to achieve an output like so where my data will have the missing rows for Saturdays and Sundays.

Output Needed:

Leave Dates	Day
05/02/2024	Monday
06/02/2024	Tuesday
07/02/2024	Wednesday
08/02/2024	Thursday
09/02/2024	Friday
10/02/2024	Saturday
11/02/2024	Sunday
12/02/2024	Monday
13/02/2024	Tuesday
14/02/2024	Wednesday
15/02/2024	Thursday
16/02/2024	Friday
17/02/2024	Saturday
18/02/2024	Sunday

Many thanks in advance folks for any help

[alexnajm]

You might want to look at the TS Filler! Then you can format as you need afterwards:  TS Filler Tool (alteryx.com)

[binuacs · Accepted solution]

@Deano478 One way of doing this

[Deano478]

@binuacs That worked like a charm, I made small tweak before outputting and found what I was looking for many thanks