Cray,
If you really wanted to noodle all of that out, I think your best bet might be to go back to what you had and then work to refine the resulting table.
So if you have row
(CCI: 123, 345, 333)
Process that to create two new rows under it and fill as:
123
345
333
If you have a row:
(CCI 012-116)
Process that to create four new rows under the first row and fill rows
012
013
014
015
016
All the other data in the original rows should stay the same.
Then just find and replace any remaining (CCI: and ) in the table with nothing.
|