Crosstab Transpose

[ZJohn]

New to Alteryx, so thanks in advance for any help anyone can provide. Below is what I'm trying to accomplish. Is this possible?

Convert this:

Company	2014	2015	2016	2017
A	100	200	300	400

To:

Company	Year	Amount
A	2014	100
A	2015	200
A	2016	300
A	2017	400

[JoshKushner · Accepted solution]

You can use the transpose tool for that

Key field: company
Data fields: all but company

Then rename the 'Name' header as 'Year' and the 'Value' header as 'Amount' with the Select tool

[ZJohn]

Thanks Josh! That is working. My example is a simplified version of what I'm trying to do, but I believe this will get me on the right track. Thanks again!