Project: Building a dataset based on US Imports. Every product has a unique identifyer (product code).

If a product qualifies for several programs, the original data set repeats the product code along with every program. The data looks something like this:

code 1 program "a" amount$
code 1 program "b" amount$
code 2 program "a" amount$
code 2 program "c" amount$
code 3 program "a" amount$

I need a column with a variable/ code that will let me know which entry program each product used. I want a dataset that looks like this:

code 1 program "a and b" amount$
code 2 program "a and c" amount$
code 3 program "a" amount$

or something like this

code 1 2 amount$
code 2 3 amount$
code 3 1 amount$

where 1=program a, 2= program a and b, and 3= program a and c