Excel Replicate values for empty cells

[satish_kumar]

Hello All,

I have an excel as follows :

Now I want the output as follows:

Note : The row count of the column2 is dynamic. Also I must not use (for each row) to fill in the details. However, I need exactly the same output as mentioned.

Thanks

Sateesh.

[Rahul_Unnikrishnan]

Hello @satish_kumar ,

Plz try to use the Fill Range Activity. It will solve your issue.

[ushu (Usha kiranmai)]

@satish_kumar You can use write cell activity to write the same data upto specific range without using any for each. Find attached workflow

Example.zip (9.6 KB)

INPUT

OUTPUT

[NIVED_NAMBIAR (NIVED N)]

Hi @satish_kumar

Use autofill range activity to autofill the data on column 1

Thanks & Regards,
Nived N

[parth.modi]

Hi @satish_kumar You can use Auto Fill Range activity which will fill the range of column1 depending on count of rows you have in that excel. Attaching an example workflow for your reference.

AutofillRange.zip (8.5 KB)

Thanks,
Parth Modi