Formula to include missing information in output

[suds144]

Hi Everyone,

I need your help. I'm using Alteryx to combine feedback survey answers. However, some weeks are missing submissions and as a result when I put them into alteryx and combine the data they do not appear in the search. Is there a formula that will include the weeks with no data?

Input:

Output:

I just need the academic week to appear in the output so I can then use this information to create a dashboard (in tableau). Thank you.

[suds144]

Thank you so much! I figured out where I was going wrong.