Transpose with headers

[JDong]

Hi Team,

Please refer to the attached excel data.

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

ID	Name	Value1	Value2	Value3	Country	ZIP Code	City	Year	Packing Costs	Material Costs
1	Apple	123	123	123	US	1234	xyz	2018	123	132
2	Apple	123	123	123	US	1234	xyz	2019	124	133
3	Apple	123	123	123	US	1234	xyz	2020	125	134
4	Apple	123	123	123	US	1234	xyz	2021	126	135
5	Apple	123	123	123	US	1234	xyz	2022	127	136
6	Apple	123	123	123	US	1234	xyz	2023	128	137
7	Apple	123	123	123	US	1234	xyz	2024	129	138
8	Apple	123	123	123	US	1234	xyz	2025	130	139

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

[ShankerV]

Hi @JDong 

One way of doing this.

Many thanks

Shanker V