If I manually input a value into 10 random cells then select their range and delete the empty cells using go to special it works as I want, but when I paste the same values into the same cells as before it won't select the empty cells for me to delete

Can someone help with this?

Thanks