Excel – Paste Data in Order of Blanks

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)