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?
column3.xlsx (9.3 KB)