Forum Discussion
Anonymous
6 years agoNot applicable
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-msftCommunity Support
Hi Anonymous ,
You could unpivot these columns as a single column in query editor.