Transpose - Column Data to Headers

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!

Alteryx Sample WF.xlsx

Datasets

Common Use Cases

Accepted answers

messi007

@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,

CrossTab_20210312.yxmd

All comments

messi007

@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,

CrossTab_20210312.yxmd

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280