delete empty entire row with condition

hello, please help to create a macro codes to delete the entire row

sample.
Y
A

1
2
3


what
when

hoe can i delete the entire empty row and leave only 1 space, however data varies everyday

perfect, i just need 1 space on colunm a need to leave 1 space

in column A Which has data, i need to have 1 space on it. thanks


it should look like this

1
2
3

a
b
c

1 space

Originally Posted by oeldere

It is usefull to add to who you are replying.

If the offered solution don't match your expectations, please add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

in column A Which has data, i need to have 1 space on it. thanks


it should look like this

1
2
3

a
b
c

1 space

Originally Posted by oeldere

It is usefull to add to who you are replying.

If the offered solution don't match your expectations, please add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

Maybe:

Please Login or Register  to view this content.

here it is.

thank you

thank you oeldere, but is that possible to do it in vba?