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,