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,
Baby

@Baby123

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

Cheers

Hi @Anil_G ,

Thank you for your response.

I will bulit and update you ASAP.

Thanks,
Baby

1 Like