Pivot Table Setup?

mikeannetta

New Member
Joined
Oct 6, 2015
Messages
7
Win 10 - Office Professional Plus 2019

I worked with Pivot Tables for years, however I've been retired for the last 5.
I have a rather large Survey that I created.
I have many questions with (Yes-No-Sometime) answers to them.
Each person has an unique #

How can I create a pivot table that that looks something like:

Question# Yes # No# Sometimes
I felt anxious 11385204
I felt nauseous 3344127

<tbody>
</tbody>








My excel data looks like (with an ID)
I felt anxiousI felt nauseous# of Symptoms – Yes (Calculated Field)# of Symptoms – Sometimes
(Calculated Field)
# of Symptoms – No
(Calculated Field)
YesYes200
NoNo8318
YesNo7022
000
000
000
NoNo4223
NoNo5519
SometimesNo8615
NoNo7517
SometimesSometimes4817
000

<tbody>
</tbody>

I am not familiar with the Data Modeling and PowerPivot. Can I do this without that? How
If I need to use Data Modeling / PowerPivot any suggestion here would help..

Thanks,
Mike
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,099,121
Messages
5,466,812
Members
406,499
Latest member
ToyoMike

This Week's Hot Topics

Top