In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Transpose with headers

JDong
8 - Asteroid

Hi Team,

 

Please refer to the attached excel data.

 

I want to transform and see the output as shown below.

 

IDNameValue1Value2Value3CountryZIP CodeCityYearPacking CostsMaterial Costs
1Apple123123123US1234xyz2018123132
2Apple123123123US1234xyz2019124133
3Apple123123123US1234xyz2020125134
4Apple123123123US1234xyz2021126135
5Apple123123123US1234xyz2022127136
6Apple123123123US1234xyz2023128137
7Apple123123123US1234xyz2024129138
8Apple123123123US1234xyz2025130139

 

How can I achieve this? Also to note is the Year column in the excel is not only year like 2018,2019 but I have noticed that it also has values like 2018 ($) or 2019 (Kg).

 

Irrespective I want to derive the above table from the excel and use for building my reports.

 

Thanks

1 REPLY 1
ShankerV
17 - Castor

Hi @JDong 

 

One way of doing this.

 

ShankerV_0-1676995853763.png

 

Many thanks

Shanker V

Labels
Top Solution Authors