Code not giving the ouptut but syntactically correct

[Veena Anoohya]

Hi,

Please help with the below code, which removes the blank cells, by replacing
the values from the below cells to the blank cells, and makes values in sequence for a cloumn.

Please Login or Register  to view this content.

[millz]

It should be:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Edit: You may want to exit the loop once you find a non-blank cell, so you don't continue all the way till the end

Please Login or Register  to view this content.

[Veena Anoohya]

It should be:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Edit: You may want to exit the loop once you find a non-blank cell, so you don't continue all the way till the end

Please Login or Register  to view this content.

Hi Millz,

Modifying with the above code, the ouput is like-

Wherever empty cells are there, the values is replaced with the successor.

I don't want the value to be repeated, instead I want all values to be consecutively
present without any blanks between them.

e.g.
if Input is-

8
9


6
4




2
1

then outout shoukd be-
8
9
6
4
2
1

[millz]

So you mean to 'delete' blank cells?

Try this

Please Login or Register  to view this content.

[GreyGhost]

Hi Veena Anoohya

... and makes values in sequence for a column.

Do you mean you want empty cells removed AND sort the remaining populated cells ?

[Veena Anoohya]

Hi Millz,

Thanks for the code


Hi GreyGhost,

Query solved, actually I wanted to delete blank cells.