Transpose - Column Data to Headers

[esjohnston]

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! 

[messi007 · Accepted solution]

@esjohnston,

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,

[esjohnston]

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?

[messi007]

@esjohnston,

If you're data is double then delete the formula:

Attached the workflow,

Regards