I can not figure out how to delete duplicate values that exist withing a row.
each row is it own data-set I could use the option to transpose a row to a column then remove the duplicates then transpose back to a row but that would take weeks since I am dealing with 30,000 rows and each row consists of 50 - 500 cells with values.

any VB or macro options to do this?