Thanks everyone for your help. I ended up using D-Ling's suggestions for the nested DO loop to check all values on each row and replacing duplicates with a missing value. One thing I did notice (prob since I'm new to this) was that I had to use ' ' instead of . to replace a value with a missing value or else the column width became extremely large.
... View more
