Removing Duplicate Values Only

I have searched and searched but can't seem to find the answer I once had.

From A2:A159 I have a list of part numbers (no duplicates). Then for each part, from Column B through Column DX there are quantity values.

Going one row at a time, I need to delete all duplicate entries.

Considerations:

Rows are independant of each other and there may be similar quantity values for different parts.

Even though the range is from B to DX, each row is unique in the total values to be considered (they range from 100+ to 1).

I was attempting to modify the following code but to no avail:

=IF(ISERROR(MATCH(0,COUNTIF(A$1:A1,Sheet1!$A$1:$A$ 20&""),0)),"",INDEX(IF(ISBLANK(Sheet1!$A$1:$A$20),"",Sheet1!$A$1 :$A$20),MATCH(0,COUNTIF(A$1:A1,Sheet1!$A$1:$A$20&""),0)))

Anyway, I am at a loss and need some help. I am attaching a copy of the file as well.

Thanks,