Hi Everyone, I am new to utilize alteryx and have question on how to create a unique row

[Pptl2022]

Hi Everyone,

This is my second post in Alteryx Community. I would really appreciate if you can help me with this question. Thank you so much in advance.

I have data in this format shown in image w title "Orig Data" Total per ID of "Orig Data"  it is "Total of Orig Data" image. I want to get to this to ensure each month column is only counted once in the final results in image w title "Expected Final Results". How do go from "Orig Data" in alteryx Designer Workflow to "Expected Final Results"? Really appreciate your support!  Thank you so much!

[Garrett_Stoker]

Workflow attached. Converting the dates into date/time format and then using a summarize tool should get you there. I set the months to count the Max value for each month, but you can tweak that if there are other numbers within those columns.

[Pptl2022]

Thank you so much @Spresza!!! Really appreciate your time and support!