Add different combinations of row values

[rickydata]

I have the following data

Item    | code

item 1 | A

item 1 | B

item 1 | C

But I want to combine codes with a different combination of other codes for the same item

Item    | code

item 1 | A

item 1 | B

item 1 | C

item 1 | AB

item 1 | AC

item 1 | BA

item 1 | BC

item 1 | CA

item 1 | CB

[AGilbert]

Should AA, BB and CC be included in the output or not?

Edited: The attached workflow matches your output. If you want the AA, BB, and CC values just remove the conditional expression and replace it with the concatenation of the code and source fields. 

[rickydata]

I should have mentioned that the first column could have mulitple values and the code field could have varying values.  

Let me attach an example. 

[AGilbert · Accepted solution]

Iterative macro attached which applies the same logic as before but to each group in order.

FYI the max iterations is set to 100 by default but can be changed in Interface Designer -> Properties.

I made the assumption that your groups are literally called '1' and '2' and used those values to match to the iteration number of the macro (see filter tool). If you're actually passing strings as test names, we will need to refactor a little. 

[rickydata]

This worked almost to perfection thanks!!!!