Transpose/Crosstab Function

[Tessa]

Hi All,

I do not have much experience using the transpose and cross tab tools in Alteryx; now I need to in order to apply a formula. I have a feeling this will be a cake-walk for someone...

Rather than typing it all out, essentially, this is what my data looks like:

And this is what I need it to look like: 

[estherb47]

Hi @Tessa 

Try a crosstab tool. For any fields you want as row headers on the left, put those in the Group by function (In your example, Products. Otherwise, that's optional)

For column headers here, you want the year field. And the values should be Qty.

You can use any summary function. Let me know if that helps!!

Cheers,

Esther

[CharlieS · Accepted solution]

Hi @Tessa 

This can be done with the CrossTab tool. Set the "Group" parameter to "Products", "Headers" to "Year", "Values" to "Qty", and "Method" to "First".

Check out the attached workflow for an example of this in action. 

[Tessa]

Worked like a charm Charlie! Thank you! 

(I love that about the Alteryx community- I just knew I could get a quick answer 🙂 ) 

[CharlieS]

I'm happy to help.