I want to transpose the value into column

[Sshasnk]

So I have a dataset that I want to transpose it. Not sure how to do it for multiple columns

Input:

Fund	sales	key/Rate	purchase	key/Rate2	Rate	key/Rate3	TR Rate
ABC	1200		1100		2300	Key	1.23
ABC	1300	Key	1200	Key	2399		1.23
ABC	1400		1300	Key	456	Key	1.23
Total	3900		3600		5155

Output:

Fund	Name	Value	Key/Rate	Total
ABC	Sales	1200		3900
ABC	Sales	1300	Key	3900
ABC	Sales	1400		3900
ABC	Purchase	1100		3600
ABC	Purchase	1200	Key	3600
ABC	Purchase	1300	Key	3600
ABC	Rate	2300	Key	5155
ABC	Rate	2399		5155
ABC	Rate	456	Key	5155

[Felipe_Ribeir0]

Hi @Sshasnk 

One way of doing this

[Sebastiaandb]

Hi @Sshasnk ,

Here you go :-). See the attached workflow. It hopefully does what you want to achieve! 

Greetings,

Seb

[gautiergodard]

Hello @Sshasnk 

Please see attached for solution !

[stefaniadurdan]

Hello.

This is my proposal for your question. Let me know if it works. If yes, I would highly appreciate marking it as an accepted solution.

[Felipe_Ribeir0]

Hi @Sshasnk 

It worked? If yes, please accept it as a solution. Thanks!