I would like to be able to group consecutive SortID's by SortType's T1,
N1 and P1. For instance, I need to be able to group SortID's 12123,
12122 & 12121. The SortID type is Number and the SortType (type) is
text. Any help would be much appreciated.
Thanks,
Scott
SortID SortType
12123 P1
12122 N1
12121 T1
12120 P1
12119 N1
12118 T1
12117 P1
12116 N1
12115 T1
12114 P1
12113 N1
12112 T1
12111 P1
12110 N1
12109 T1
12108 P1
12107 N1
12106 T1