Hello All,
I have the below use case (a table) from where I have to combine values from each cell. Can you help me with a solution?
Input Table:
20.0% | 35.0% | 50.0% | 60.0% | 70.0% | 75.0% | 80.0% | |
1 | 0.06619383% | 0.119339207789523000000% | 0.17569% | 0.21621% | 0.25968% | 0.34612% | 0.58415% |
1.25 | 0.07851% | 0.14440% | 0.21669% | 0.27080% | 0.44303% | 0.69673% | 1.06059% |
1.5 | 0.09170% | 0.17197% | 0.25986% | 0.32800% | 0.79217% | 1.15143% | 1.54705% |
2 | 0.13562% | 0.25575% | 0.39006% | 0.92259% | 1.69587% | 2.12179% | 2.53649% |
2.25 | 0.19071% | 0.42039% | 0.65006% | 1.27980% | 2.18416% | 2.61292% | 3.03552% |
2.5 | 0.25527% | 0.60515% | 0.95502% | 1.72720% | 2.66757% | 3.11086% | 3.53236% |
2.75 | 0.39956% | 0.84918% | 1.29879% | 2.20178% | 3.15756% | 3.61458% | 4.03138% |
3.00 | 0.55577% | 1.10657% | 1.65736% | 2.69006% | 3.65433% | 4.10763% | 4.53260% |
Expected output:
1 | 0.0662% | 0.000661938330225848, 0.00119339207789523 | 0.000661938330225848, 0.00119339207789523, 0.00175688664189115 |
1.25 | 0.0785% | 0.000785126624669136, 0.00144397159317099 | 0.000785126624669136, 0.00144397159317099, 0.0021668981943259 |
1.5 | 0.0917% | 0.000916994513087872, 0.00171966658584245 | 0.000916994513087872, 0.00171966658584245, 0.00259860873169927 |
1.75 | 0.1059% | 0.00105913361914717, 0.00199348383350755 | 0.00105913361914717, 0.00199348383350755, 0.00305599731317405 |
2 | 0.1356% | 0.00135616832358946, 0.00255748304472648 | 0.00135616832358946, 0.00255748304472648, 0.00390062489060631 |
2.25 | 0.1907% | 0.00190714536702702, 0.00420386252849896 | 0.00190714536702702, 0.00420386252849896, 0.0065005796899709 |
2.5 | 0.2553% | 0.00255269279937671, 0.00605146344867867 | 0.00255269279937671, 0.00605146344867867, 0.00955023409798062 |
2.75 | 0.3996% | 0.00399564192659483, 0.00849176790552617 | 0.00399564192659483, 0.00849176790552617, 0.0129878938844575 |
3 | 0.5558% | 0.00555774161178595, 0.0110656927296811 | 0.00555774161178595, 0.0110656927296811, 0.0165736438475763 |
Solved! Go to Solution.
Thanks All, that worked!!