that is correct. for instance gross josh might appear multiple times and each time have different columns filled in for each record. for the most part there are only duplciates nothing more for a record. some records do not have any data just a duplicate. i want to consolidate all this data so each name has one record and all extended data.