Please help me transform my data

[RajatRehria]

Hi all, the below is my input and i want output like this, is there any possible way?

Input:

FUND ID	Short	Long	Total	Months
1234	3406865910	4962629341	8369495251	12
5678	145786478	319700063	465486540.7	12
9999	961990129	112111274	1074101403	10

Output:

FUND ID	Short	Long	Total
1234	3406865910	4962629341	8369495251
Months	12	12	12
Avg	283905492.5	413552445.1	697457937.5
5678	145786478	319700063	465486540.7
Months	12	12	12
Avg	12148873.17	26641671.92	38790545.06
9999	961990129	112111274	1074101403
Months	10	10	10
Avg	96199012.9	11211127.4	107410140.3

[binuacs]

@RajatRehria one way of doing this

[flying008]

Hi, @RajatRehria 

FYI.

[RajatRehria]

Hi @flying008 thanks for the solution, can u pls share the workflow as well.

[flying008]

Hi, @RajatRehria 

[RajatRehria]

 @binuacs while using ur macro i am getting this error

[RajatRehria]

Hi @flying008 are u not able to share the workflow? the video u shared is difficult to follow along as i can pause it. Please share the workflow if u have built. Thanks.

[flying008]

Hi, @RajatRehria 

Due to security policies, I am unable to upload any yxmd. Sorry!  

But you can snap the gif for tool option setup.

[binuacs]

@RajatRehria @Map the fund if field in the macro question field( click the macro on the left side top you will see the options)

[jdminton]

Here is the workflow.