How could I replicate the formula until the last row?

[pprin001 (Paolo70)]

Hello guys.

After introducing a new column “Key” before the column “SKU”. I need to insert a formula in the new column “Key” which has the column letter “E”

“=“CONCAT(F2;H2;J2)”” in the “E2” cell.

But I’m getting an error/message like to insert an object value but I’m confused …

Finally, I’d like to replicate this formula until the last row with the value “E20” but It would change so It has to be dynamically … For example, It could be “E300” I mean we don’t know the end.

I’m uploading the test.xlsx and the file.xaml

Thanks.

Main.xaml (7.0 KB)

test.xlsx (10.4 KB)

[rikulsilva (Henrique Lima da Silva)]

Hi
Put = inside quotes

“=concat…”

[nameless]

You need to find the index of your last row, either by using the Find Last Data row activity or reading a DataTable and getting row count. Then use Fill Range activity to fill the formula for the range