Connecting multiple data points

[matout]

Hello,

I am trying to analyze a survey answers which has 800+ rows based on multiple data points, from within the some questions answers. the survey has 119 questions, each question with 5 options.

For example

I want to classifiy each rows as 

- Organized, semi organized, not organized.

by

Organized classification is 

Question number	Option
Question 1	Option 2
Question 5	Option 3
Question 6	Option 4
Question 13	Option 5
Question 44	Option 1

And semi organized as for example

Question number	Option
Question 1	Option 3
Question 5	Option 1
Question 6	Option 5
Question 13	Option 2
Question 44	Option 4

is this obtainable? and how 

thank you 

[amitchandak]

@matout , a new column like

new column =
Var _1 = if([Bank Account]= "Yes" ,1,0) + if(not(isblank([Accounting Practice])),1,0)+ if([Accountant]= "Yes" ,1,0) + if([External Auditor]= "Yes" ,1,0) + if([Online Banking]= "Yes" ,1,0)
return
Switch( True() ,
_1 = 5, "Organized",
_1 >0 , "Semi Organized",
"Not organized"
)

Change as per need

[matout]

Hello, thank you for the answer.

this solution is helpful, however, there are 3 different values in the "Accounting practice" column.
How can I diffrentiate them, this is not just true or false.

[amitchandak]

@matout ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[matout]

Hello, thank you for the answer

I have a survey. with 119 question, each question is a column. 

each answer  for the survey is a row in the table.

for example

Company ID    Bank Account?       Accounting Practice     Accountant?      External Auditor    Online Banking?     

1                            yes           Accounting system                  Yes                         No            No          No                 

2                            No            Accounting records                 Yes                         No            No          No                 

3                            Yes          Accounting system                    Yes                        yes           Yes         No                 

I want to classify each company (row) as Organized, Semi Organized and Not organized.

based on thier answers to the questions. 

For example, if a company has a bank accout, Accounting practice, Accountant, Registered trade name and Tax number

this company will be labeled as organized. 

I have other criteria for semi organized and other for not organized

Is this obtainable and how?

Thank you