Summarise multiple column counts

[SarahFenton]

Hi 

I have created a file containing several columns with the options Yes or No, and want to summarise this info to show the counts for each column.  Currently, when I use the summarise tool to review the counts it splits out the data into multiple rows/columns and I am unsure how to go from what I have in my workflow to the required summary below:

Required Summary
	Result 1	Result 2	Result 3
Yes	5	3	5
No	3	5	3

I'm very new to Alteryx so any help is appreciated!  I've attached the sample workflow as reference. Thanks!

[gawa · Accepted solution]

hi @SarahFenton 

You need to Transpose and Cross-tab like this.

[SarahFenton]

Thats great - thank you 😊