First, create a dictionary object to store unique values, then loop through Column C of DataSheet (starting at row 2 to skip header), then add each non-empty value to the dictionary (dictionaries automatically handle uniqueness), finally transfer the unique values from the dictionary to Column 16 of the Divide sheet