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 |
