I want to transpose the value from row to column

[Sshasnk]

Below is my input

Input:

Fund	Purchase	sell	sum_purchase	sum_sell	difference1	difference2
ABC	10	5	7	3	5	4

We can remove the below formula and add it after the transposition as well

Difference1 = Purchase - Sell

Difference2 = Sum_purchase - sum_sell

Output:

Fund		Value	Value2
ABC	Purchase	10	7
ABC	sell	5	3
ABC	Difference	5	4

[Sebastiaandb · Accepted solution]

Hi @Sshasnk ,

I believe this is what you want to achieve :-), 

Let me know if it works for you, 

greetings,

Seb