Why would 80 be paired with 77?

But then the last number of the second sequence should be 81, not 77, so like @ebygomm said, why that matchup?

Can be even numbers from 2 to 12 and odd numbers from 3 to 23. (i.e. 6 numbers appears in column Nr. 1 and 11 numbers in column Nr. 2) the table posted is only for example.

But, how do you know what numbers you want to pair? Is it just the last one that's out of order? So in the 2-12 and 3-23 one, do you want:

Or what pairing do you want? If you know the formula, i.e. the relation between the lower number and the higher one, then @redgeographics is on the money. Otherwise, if you know each numbers buddy-number (i.e. the odd one), using an AttributeValueMapper might be useful. Can you clarify what the relation is between the two sets of numbers?

I've simplified the problem a little bit, and I have the following data:

Where A_MIN it represents the lowest even number and A_MAX represents the highest even number.

same with B_MIN and B_MAX.

I'm thinking about two types of results:

1.

Or:

2.

Excellent! So, for result 1) you can rely on this formula:

Number_diff = (Max-Min)/2 + 1(you'll need to add 1, since you're also including the upper bound). I.e. (A_MIN - A_MAX)/2 +1 = A_COUNT -> (12-2)/2 = 5, 5+1 = 6 = A_COUNT.

For 2) I'll try to get a small example workspace for you. However, is it correct that f.ex. the 4th row (X 8 1) has Name = X? Seeing as we've "run out" of B-values for feature X. I'll trust that your example is right though, and proceed as such.

Self-reply: See if this is useful @sorindurutable_pair_builder.fmw - I've built it in 2020.0, hope that's good for you.table_pair_builder.fmw