Combining Values

[ANANDPRABHU]

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

[AngelosPachis · Accepted solution]

Hi @ANANDPRABHU ,

Here's one way to do this

Hope that helps.

Cheers,

Angelos

[ANANDPRABHU · Accepted solution]

Thanks All, that worked!!