Hi everyone!

I wanted to follow up that I did get my answer, but first, a big thank you to xladept for all your help and support! I didn't end up using your macro, but your efforts were much appreciated.

What I did end up doing to satisfy my objective is:
  1. Select All columns with data.
  2. Click Data in the Ribbon tabs.
  3. Click Remove Duplicates from the options under Data.
  4. Click Unselect All, then fill in the checkbox of the 1 column that I wanted to remove duplicate data.
  5. Click OK to remove duplicate data from the 1 specified column. This now shows me only the unique data from that column, with no duplicates.

Thanks again!