Analyst

Hi,

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. 

                               Yes    No

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?

By: tee

Leave a Reply

Your email address will not be published. Required fields are marked *