We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parsing Cells into multiple rows

PraveenX
6 - Meteoroid

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 operations4.08
NAV, end of period$119.71
Ratios to average net assets:(2) 
Total expenses0.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 operations26.65
NAV, end of period$882.28
Ratios to average net assets:(2) 
Total expenses0.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 operations4.05
NAV, end of period$119.80
Ratios to average net assets:(2) 
Total expenses0.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 expenses0.10%
Net investment income/(loss)-0.05%
Total return(3)-3.93%

 

Someone please help.

 

Thanks,

5 REPLIES 5
vizAlter
12 - Quasar

@PraveenX — Can you attach your MS Excel file for testing the data minutely?

PraveenX
6 - Meteoroid

Please find the data attached below.

 

Thanks

PraveenX
6 - Meteoroid

@

 

Please find below the input file.

 

Regards,

Praveen

Greg_Murray
12 - Quasar

Hi @PraveenX ,

 

This isn't the most dynamic solution, but it should get you going. 

 

Greg_Murray_0-1603373636670.png

 

Greg

 

PraveenX
6 - Meteoroid

Thanks a ton Greg.

Labels
Top Solution Authors