Pivot table data layout

[thp510]

This is embarrassing but hope this is because I've been a bit rusty on excel vs it being an excel issue. Here's the data set I'm trying to make a pivot table out of the following data set....

Time on Seat

<tbody>
<sup>[TD]Did you like onboarding?[/TD]
[TD]Did you do your hw?[/TD]
[TD]Was he helpful?[/TD]
[TD]Did He help when asked?[/TD]
[TD]Could you Find him?[/TD]

[TR]
[TD]1 month[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No [/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]2 months[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]1 month[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]1 month[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]</sup>
</tbody>

I then want to make a pivot table to tally up the results (count # of yes and no) so it looks like this...

FILTER:	<strike></strike>Time in Seat	<strike></strike>= 1 month<strike></strike><strike></strike><strike></strike>
<strike></strike>	<strike></strike>YES	NO
Did you like onboarding?<strike></strike><strike></strike>	<strike></strike>2	1
Did you do your hw?<strike></strike>	<strike></strike>3
Was he helpful?<strike></strike>	<strike></strike>1	2
Did He help when asked?<strike></strike>	<strike></strike>3
Could you Find him?<strike></strike>	<strike></strike>1	2

<tbody>
</tbody>

I tried dragging the column headers in the raw data seat into the ROWs fields but it won't populate this way? What am I doing wrong? I'm on Excel 2016 and I choose Tabular Formatting to get it to look like the old Excel Pivot Tables (which I truly miss). Thank you!

 

[thp510]

Re: Basic pivot table question (embarrassing) Someone

Anyone? Do I need to just conduct a COUNTIFS function?

 

[RoryA]

Re: Basic pivot table question (embarrassing) Someone

Your data set doesn't really lend itself to pivot tables with its current layout. COUNTIF would be much simpler.