Hello,
I have a data set that vertically stacks records by month and I need Alteryx to convert (transpose) the data to where the quantitative fields (Sales, Redemptions, Assets) are side by side - by month - in a more linear fashion. I know there's the crosstab and transpose tools but not too familiar with using them. Any suggestion on how to go about this? Attached is a file to help illustrate current state vs. desired state. Thanks.
Solved! Go to Solution.
Thank you both! Will have to give the nod to @binuacs as I will be running this workflow on a rolling 3 month basis so the having the dynamic rename tool will help with that.