The issue is that I need multiples for row B and for row N, but want to exclude the additional multiples. Like I want to be able to say that when Row B = x, keep the one instance of 1-6 in column N and then filter out the rest. And then the same when B = y.

The finished product would look like:

123-45-6789____1____0.09%
123-45-6789____2____0.35%
123-45-6789____3____0.1%
123-45-6789____4____0.5%
123-45-6789____5____0.41%
123-45-6789____6____ 6 0.29%
222-465-69_____1_____0.39%
222-465-69_____2_____0.256%
222-465-69_____3_____0.31%
222-465-69_____4_____0.742%
222-465-69_____5_____0.00%
222-465-69_____6_____0.08%