PASTE NON BLANK CELLS ONLY USING EXCEL

Tip: This is also useful when you create a data validation list from a range with blank cells in it. In that case you can create a new range with non-blank cells using above formula and then use this new range for data validation.