Relationships

[SylviaK]

Hi

I would like to generate a relationship table as shown below, but struggling: 

Input		Output
Record ID	Participants			Bob	Nick	Sofia	Dan	Evan	Stefan
1	Bob, Nick		Bob	1	2	0	0	0	1
2	Bob		Nick	2	1	0	0	0	1
3	Sofia, Dan, Evans		Sofia	0	0	0	1	1	0
4	Nick		Dan	0	0	1	0	1	0
5	Stefan		Evan	0	0	1	1	0	0
6	Bob, Nick, Stefan		Stefan	0	1	0	0	0	0

Many thanks, 

[atcodedog05 · Accepted solution]

Hi @SylviaK 

Interesting usecase. Here is how you can do it.

Workflow:

Hope this helps : )