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....

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Time on ^{Seat[/TD]
[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]
[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]}
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]FILTER: [/TD]
[TD]<strike></strike>Time in Seat [/TD]
[TD]<strike></strike>= 1 month<strike></strike><strike></strike><strike></strike>[/TD]
[/TR]
[TR]
[TD]<strike></strike>[/TD]
[TD]<strike></strike>YES[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Did you like onboarding?<strike></strike><strike></strike>[/TD]
[TD]<strike></strike>2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Did you do your hw?<strike></strike>[/TD]
[TD]<strike></strike>3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Was he helpful?<strike></strike>[/TD]
[TD]<strike></strike>1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Did He help when asked?<strike></strike>[/TD]
[TD]<strike></strike>3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Could you Find him?<strike></strike>[/TD]
[TD]<strike></strike>1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


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.