In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx to make sure you have filled out your security questions.
Learn more here
I used a multi row to fill down the store, then a filter, and finally a couple of data transformation tools. Screenshot is below and workflow is attached!