Needing to transpose data

[Jake5]

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.  

[PanPP]

Hi @Jake5 

I have provided a sample WF that accomplishes your output.

[binuacs · Accepted solution]

@Jake5 One way of doing this

[Jake5]

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.