Extrapolation of data

Anonymous I guess the ask from the user is to generate the 2 table that you have already created.
How to extrapolate to the below table from the source seems to be his ask ? and also derive other columns

I am not sure, but we can create a calendar table and then use cross join filter condition to derive it but I might be wrong here