Need to update excel in alternate colimns


I need to update excel in alternate column as mentioned in image for example if the column B is updated I need to update in colD similarly if B and D are updated need to update in colF

How the values are being updated ? Like in what values are calculated which need to be updated ?

I will get the values from another excel ,i will update it in column wise,that I am able to update but I am unable to update in alternate column if I filled B column C column should not be filled D column should be filled

Hi @sruthesanju ,

You can use this test file

Test.xaml (10.3 KB)

First run workflow as it is.
If you feel output is correct then just write range and pass dtInput

Let me know if you face any issue

Hi @sruthesanju ,

Is this worked for you ?