AjayChawda
2 years agoNew Contributor II
create combination of data after reading excel file
Hello Experts,
Trying to create combination of records after reading excel file.
number of column are dynamic.
sharing expected result of screenshot
Can anyone help me to achieve this.
thought to use script snap but got stuck as we have dynamic column structure .
each combination result will create new role with column name like start date, end date,result of combination(eg B2 C2)
index statdate enddate value
1 05/31/2015 06/30/2015 B2*C2
2 05/31/2015/ 07/30/2015 B2*D2
3 05/31/2015 08/31/2015 B2*E2
...
Thanks in advance.