Split data in multiple tables

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.

Workflow

Reporting

Transformation

Accepted answers

philipmannering

You could do something like this,

Arrange columns.yxmd

All comments

Is this same as this post?

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

philipmannering

You could do something like this,

Arrange columns.yxmd

Hi @PhilipMannering

awesome, that's it!

Thanks a lot 🙂

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

Output:

Hope this helps 🙂

Arrange columns.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703