Pivot Table Setup?

[mikeannetta]

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:

[TABLE="width: 485"]
<tbody>[TR]
[TD]Question[/TD]
[TD]# Yes [/TD]
[TD]# No[/TD]
[TD]# Sometimes[/TD]
[/TR]
[TR]
[TD]I felt anxious [/TD]
[TD]113[/TD]
[TD]85[/TD]
[TD]204[/TD]
[/TR]
[TR]
[TD]I felt nauseous [/TD]
[TD]334[/TD]
[TD]41[/TD]
[TD]27[/TD]
[/TR]
</tbody>[/TABLE]








My excel data looks like (with an ID)

I felt anxious	I felt nauseous	# of Symptoms – Yes (Calculated Field)	# of Symptoms – Sometimes (Calculated Field)	# of Symptoms – No (Calculated Field)
Yes	Yes	2	0	0
No	No	8	3	18
Yes	No	7	0	22
		0	0	0
		0	0	0
		0	0	0
No	No	4	2	23
No	No	5	5	19
Sometimes	No	8	6	15
No	No	7	5	17
Sometimes	Sometimes	4	8	17
		0	0	0

<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