Concate fields with unique identifier

[HM]

Hi,

I'm looking to concat the contect of 2 cells based on the unique identifier to create a new field without changing the structure of the data:

Input:

ID	Type	Name
1	Enabler	apples
2	Dependent	wine
1	Dependent	juice
3	Dependent	chips
3	Enabler	potatoes
2	Enabler	grapes

Desired output:

ID	Type	Name	Concatenated field
1	Enabler	apple	apple juice
2	Dependent	wine	grape wine
1	Dependent	juice	apple juice
3	Dependent	chips	potato chips
3	Enabler	potato	potato chips
2	Enabler	grape	grape wine

Thanks

[MarqueeCrew]

The plurals in the examples are ignored.

Take your input and filter it on type == "Enabler"

Setup 2 join tools

1. True to left & false to right (from filter). Join key is ID.
2. true to right & false to left (from filter). Join key is ID.

3. Union both Join outputs (J) together.

4. Formula: concatenated field gets;

[name] + " " + [right_name]

5. Select to cleanup fields.

I think that this should get you where you are trying to go.

Thanks,

Mark

[MarqueeCrew]

You will need to have a formula after each join. You'll setup the concatenated field with the appropriate enabler and dependent field. 

Then you can select, cleanup and union the data back together. 

Minor revision. 

[MarqueeCrew · Accepted solution]

It is morning and a module is here now.  It is very close to the descriptions of a sleepy community member.