ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
It works but I kind of don't like it (the double transpose in the second part). I feel it should have been made differently. I'll browse through other solutions later.