Hello, I am a new Alteryx user. I want to transpose and reformat my data. Please see attached file that has an example of original data and desired data.
The year is currently in a column. I want to make the year as the header for each account so I can perform percentage change analysis YOY.
Thanks in advance!
Solved! Go to Solution.
Please see below:
Attached the workflow,
Hope this helps!
Please mark the answer as solved if it solve your need, it will help others.
Regards,
Just what I needed - thank you! My only issue is that my original data type is "double." I had to change the type to VW string in order for the number formula to not give me a parse error. Does that formula only work for string/text type data?