Hi All,
I have a Data in excel like this :
| Class A Class A Class Q Class S |
| Series NIE Series NIR Series NIE Series 3 |
| Per unit operating performance: |
| NAV, beginning of period 115.63 855.63 115.75 23.93 |
| Income/(loss) from operations: |
| Net realized and unrealized gain/(loss) 4.12 26.92 4.09 (0.91) |
| Net investment income/(loss) (0.04) (0.27) (0.04) (0.03) |
| Total income/(loss) from operations 4.08 26.65 4.05 (0.94) |
| NAV, end of period 119.71 882.28 119.80 22.99 |
| Ratios to average net assets:(2) |
| Total expenses 0.06% 0.06% 0.06% 0.10% |
| Net investment income/(loss) (0.03)% (0.03)% (0.03)% (0.05)% |
| Total return(3) 3.53% 3.11% 3.50% (3.93)% |
I want to convert into like this :
| | Class A |
| | Series NIE |
| Per unit operating performance: | |
| NAV, beginning of period | $115.63 |
| Income/(loss) from operations: | |
| Net realized and unrealized gain/(loss) | 4.12 |
| Net investment income/(loss)(1) | -0.04 |
| Total income/(loss) from operations | 4.08 |
| NAV, end of period | $119.71 |
| Ratios to average net assets:(2) | |
| Total expenses | 0.06% |
| Net investment income/(loss) | -0.03% |
| Total return(3) | 3.53% |
| Class A | |
| Series NIR | |
| Per unit operating performance: | |
| NAV, beginning of period | $855.63 |
| Income/(loss) from operations: | |
| Net realized and unrealized gain/(loss) | 26.92 |
| Net investment income/(loss)(1) | -0.27 |
| Total income/(loss) from operations | 26.65 |
| NAV, end of period | $882.28 |
| Ratios to average net assets:(2) | |
| Total expenses | 0.06% |
| Net investment income/(loss) | -0.03% |
| Total return(3) | 3.11% |
| Class Q | |
| Series NIE | |
| Per unit operating performance: | |
| NAV, beginning of period | $115.75 |
| Income/(loss) from operations: | |
| Net realized and unrealized gain/(loss) | 4.09 |
| Net investment income/(loss)(1) | -0.04 |
| Total income/(loss) from operations | 4.05 |
| NAV, end of period | $119.80 |
| Ratios to average net assets:(2) | |
| Total expenses | 0.06% |
| Net investment income/(loss) | -0.03% |
| Total return(3) | 3.50% |
| Class S | |
| Series 3 | |
| Per unit operating performance: | |
| NAV, beginning of period | $23.93 |
| Income/(loss) from operations: | |
| Net realized and unrealized gain/(loss) | -0.91 |
| Net investment income/(loss)(1) | -0.03 |
| Total income/(loss) from operations | -0.94 |
| NAV, end of period | $22.99 |
| Ratios to average net assets:(2) | |
| Total expenses | 0.10% |
| Net investment income/(loss) | -0.05% |
| Total return(3) | -3.93% |
Someone please help.
Thanks,
