count the occurrences of pairs of attributes

giorogo
giorogo New Altair Community Member
edited November 5 in Community Q&A

Hi everyone, I'm a newbie of the program; I have this table excel (extract, complete file attached):

tabella17.png

each row has only one 2 and only 3.

I want to create a pattern that identifies the numbers and generates the pairs of emotions; for example for the line with the id: 2271 there is 2 for neutral and 3 for disgust -> the generated couple is neutral, disgust; for the row with id 2678 there is 3 happiness for and 2 for disgust -> the generated pair is happiness, disgust 

Can someone help me?

Tagged:

Answers

Categories