Combining values from columns

excel
activities

#1

Dear reader,

I my Excel I have:

  • a column 1 which contains data on each row
  • a column 2 which contains data on some rows

I would like to have in column 3, that each row in column 3 is identical to column 2, however hen there is no value in this row in column 2, it gets the value of the row above from column 3.

I explained this column 3 also with a formula in my Excel, attached to this message.

Does anyone know how I can build this with a Foreach row in a Datatable activity in a workflow?

Best, Matt

column3.xlsx (9.3 KB)


#2

@mattsheep

please try and let me know if that helps ?

Thanks~Rajesh

Main.xaml (12.5 KB)


#3

Dear @rajeshprabhu_gp,

This is very good, this what I am looking for. Thank you so much. First time right, great man.

Best, Matt