Forum Discussion

AjayChawda's avatar
AjayChawda
New Contributor II
2 years ago

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.