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

I want to transpose the value into column.yxmd