Transpose help

[Chelseaa]

Hi all, 

I need some help regarding this:

Input file: 

Region	Month	Product Cost	Transport	Savings
AMER	Jan	3	4	-1
AMER	Feb	2	3	-2
AMER	Mar	2	2	0
APAC	Jan	6	5	-1
APAC	Feb	7	2	-0.5
APAC	Mar	5	3	0

Desired Output file:

Region	Month	Cost Type	Value for Col 1	Value for Col 2
AMER	Jan	Product Cost	3
AMER	Jan	Transport	4
AMER	Jan	Savings		-1
AMER	Feb	Product Cost	2
AMER	Feb	Transport	3
AMER	Feb	Savings		-2
AMER	Mar	Product Cost	2
AMER	Mar	Transport	2
AMER	Mar	Savings		0
APAC	Jan	Product Cost	6
APAC	Jan	Transport	5
APAC	Jan	Savings		-1
APAC	Feb	Product Cost	7
APAC	Feb	Transport	2
APAC	Feb	Savings		-0.5
APAC	Mar	Product Cost	5
APAC	Mar	Transport	3
APAC	Mar	Savings		0

I have tried to transpose twice, but i have no idea how to merge "savings" under the "Cost type" column.

Thank you in advance!

[Raj_Singh1 · Accepted solution]

Hi @Chelseaa 

Please see attached. Can you please accept it as solution if its work for you . if any issues let me know and i can make changes to workflow .

Thanks 🙂

[AbhilashR]

Hi @Chelseaa, @Raj_Singh1 has already presented an approach but I wanted to propose an alternate way of reaching the same goal. 

I hope this helps.