Request for HELP multiplex network

Feb 6 at 5:37 PM

I need to create an network with edges of affiliation: friendhip and trust which are simultaneously appearing between the nodes.

The data that I have are in Excel: so Vertex 1, Vertex 2, Intensity of relationship and the other column which has all affiliation: friendhip, trust, love, hate etc...

How do I build a network (how can I filter the data) in order to capture only pairs which indicated on Vertex 2 simultaneusly both of those 2 affiliations friendhip and trust and how do I sum up intensity of those 2 affiliations? Intensity is done not in merging the counts but manually by respondents : high fiendship level: 3, middle friendhip level: 2 and low friendship level 1.

Please help.