i am unable to understand - did you want distinct values for duplicate percentages, or not?

for example, in the sheet that i uploaded in my post (#7), N40 and N41 both have 0.2%, but M40 and M41 have Y and Z corresponding to them. did you want that to happen or did you just want Y repeated twice?

if you just wanted Y repeated twice, @micope21's uploaded file does that already.