select range - press F5 (Go To) click Special (button in dialog box) select blanks (option) click Ok (button) ctrl + '-' (ctrl + minus : gives you delete dialog box) shift cells up (option) click Ok (button)
Just watched your video in 2024, Apr 14th! Thank you Gentleman! always wanted to do this but a bit lazy to Google it up and watch any videos finally happy that I got what I wanted in the first youtube video itself!