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:

Question	# Yes	# No	# Sometimes
I felt anxious	113	85	204
I felt nauseous	334	41	27

<tbody>
</tbody>

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