How to copy one cell data into different rows of same cell using UI path

Hi team,
I have one excel with som data.

I need to fill the empty cell with above cell data .
Please find the input screenshot for your reference below

In the above attachment I have empty cell A3:B8.
So, in that empty cell i need copy above cell data into empty cells

I need to copy the A2 cell into below the empty cell in a same row .
We have C colomn have 8cell data right .
So I need to copy A2 cell data upto A8 and B2 cell data upto B8.
I am attaching the output screenshot for better understanding.

I highlighted data i need to write dynamically

Sometimes we have 1 or more rows of data in C colomn
But how many rows of data is there in C colomn i need to copy the A and B cell data.

Please help me to solve the issue ASAP.

Thanks in advance,


Use auto fill range activity…it will fill the data automatically till the end of data


Hi @Anil_G ,

Thank you for your response.

I will bulit and update you ASAP.


1 Like