I have 2 columns with Ip address information:
<tbody>
</tbody>
I'd like to return for every grouping of column 1 the missing values from 1-254 in column 2
So for example, an output of the above data would show something like:
1.1.1.1 to 1.1.1.99
1.1.1.102 to 1.1.1.254
1.1.2.1 to 1.1.2.94
1.1.2.96 to 1.1.2.199
1.1.2.201 to 1.1.2.254
Column1 | Column 2 | Column 3 |
1.1.1 | 100 | |
1.1.1 | 101 | |
1.1.2 | 95 | |
1.1.2 | 200 |
<tbody>
</tbody>
I'd like to return for every grouping of column 1 the missing values from 1-254 in column 2
So for example, an output of the above data would show something like:
1.1.1.1 to 1.1.1.99
1.1.1.102 to 1.1.1.254
1.1.2.1 to 1.1.2.94
1.1.2.96 to 1.1.2.199
1.1.2.201 to 1.1.2.254