Split data in multiple tables

[tanja90]

Hello,

I have input like in example excel (sheet: "old") and I want to create output like in sheet "new".  Values for column Years is not fixed, I'm expecting values for additional years. But I don't know how to do it, any help would be great.

Thank you for your time.

[atcodedog05]

Hi @tanja90 

Is this same as this post?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Split-data-based-on-column-value/m-p/6...

[PhilipMannering · Accepted solution]

Hi @tanja90 

You could do something like this,

[tanja90]

Hi @PhilipMannering 

awesome, that's it!

Thanks a lot 🙂

[atcodedog05]

Hi @tanja90 

Just a slight modification to @PhilipMannering to match headers as expected output

Output:

Hope this helps 🙂

[tanja90]

@atcodedog05 

Thank you 🙂