['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:']