I am not sure if this is the appropriate place to ask this question. I’ll go ahead please indulge me.
In my Pivot, i have several questions that have two options “Yes and No”. I want to count each questions answer and put them in columns. E.g.
Count of Diapers 2 4
Count of Toys 4 5
Count of Shoes 6 1
OR it can be in another format
Count of Diapers Count of Toys Count of Shoes
Yes 2 4 6
No 4 5 1
How can I achieve this in Excel pivot please?