How to copy and paste data over and not override data that’s already present and correct in a column or a row

• Keep data unfiltered
• Select column of data to be copied
• Click on column you want to pate into
• Right click – Paste special – special – skip blanks (check box)