Hello,
I am trying to get records placed into two different columns depending on each grouping of ranges on dn1 and Ext in table example below:
If dn1/ext is asingle range then needs to be separated with a comma ',", else is in subsequent ranges then separation with a dash "-"
Results would need to be per each group like in Ext Results and dn1 Results column.
Any help would be greatly appreciated.
<tbody>
</tbody>
I am trying to get records placed into two different columns depending on each grouping of ranges on dn1 and Ext in table example below:
If dn1/ext is asingle range then needs to be separated with a comma ',", else is in subsequent ranges then separation with a dash "-"
Results would need to be per each group like in Ext Results and dn1 Results column.
Any help would be greatly appreciated.
Group | dn1 | Ext | Ext Results | dn1 Results |
Group A | \+19725551000 | 1000 | 1000,1031-1035,1055 | \+19725551000,\+19725551031-\+19725551035,\+19725551055 |
Group A | \+19725551031 | 1031 | ||
Group A | \+19725551032 | 1032 | ||
Group A | \+19725551034 | 1034 | ||
Group A | \+19725551035 | 1035 | ||
Group A | \+19725551055 | 1055 | ||
Group B | \+19725551036 | 1036 | 1036-1037,1060 | \+19725551036-\+19725551037,\+19725551060 |
Group B | \+19725551037 | 1037 | ||
Group B | \+19725551060 | 1060 |
<tbody>
</tbody>