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.
Hello @satish_kumar ,
Plz try to use the Fill Range Activity. It will solve your issue.
@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)
Use autofill range activity to autofill the data on column 1
Thanks & Regards,
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)