Dyanmically Transpose Year fields from rows into columns

[TanvirAhmed]

Hi,

How would I transpose the below dynamically to get years as columns instead of rows (without filtering the years and joining on the common field period etc). I want the years to flow through automatically when there is a new one, instead of adding a filter everytime. Essentially I want it how its displayed in the second screenshot.

Thanks!

 

 

  

[OllieClarke]

Hi @TanvirAhmed you'll want the cross-tab tool for this: check out the example workflow and this blog: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Cross-Tab/ta-p/4368

If you post some sample data we can help you with the workflow

Ollie

[TanvirAhmed]

Hey! Thanks, I've attached an example workflow with some input sample data. 🙂

[OllieClarke · Accepted solution]

Hey @TanvirAhmed this workflow should get you where you need to be: