Question: how to copy and paste in excel without blank cells?
Answer: Then select another range or cell that you need to paste the data, and then right click, choose Paste Special > Paste Special from the context menu, see screenshot:
In the Paste Special dialog box, check Skip blanks option, see screenshot: