Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group Columns with CountIf

Hello everyone,

Is there a way we can group multiple columns and then enforce a COUNTIFS function?


 

I have multiple columns that I would like to group them into one single column, and then to enforce a countif function. The columns here have a "yes" and "no" answer so it's basically the same for all.

Appreciate the help and support from you guys here! Thank you so much!

 

  • Hi Anonymous ,

     

    You could unpivot these columns as a single column in query editor.

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    Hi Anonymous ,

     

    You could unpivot these columns as a single column in query editor.