• I have made some clarification.

    I basically want COL3 to return the Distinct values of COL2, (remove duplicates from COL2 and return the unique values in COL3. Hope am much clear now.