cancel
Showing results for 
Search instead for 
Did you mean: 

create combination of data after reading excel file

AjayChawda
New Contributor II

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

...

 

AjayChawda_0-1716297709758.png

 

Thanks in advance.  

 

2 REPLIES 2

Aleksandar_A
Contributor III

Hello @AjayChawda,

Could you please share the sample Excel File that you have attached as a screenshot?

I think I have an idea on how we can approach this, we can give it a shot 😄

Regards,

Aleksandar.

hi @Aleksandar_A 

sample file is attached.