Pivot table data layout

thp510

Board Regular
Joined
Oct 19, 2015
Messages
73
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>
[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]
</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>YESNO
Did you like onboarding?<strike></strike><strike></strike><strike></strike>21
Did you do your hw?<strike></strike><strike></strike>3
Was he helpful?<strike></strike><strike></strike>12
Did He help when asked?<strike></strike><strike></strike>3
Could you Find him?<strike></strike><strike></strike>12

<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

Board Regular
Joined
Oct 19, 2015
Messages
73
Re: Basic pivot table question (embarrassing) Someone

Anyone? Do I need to just conduct a COUNTIFS function?
 
Last edited by a moderator:

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,584
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
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.
 

Forum statistics

Threads
1,085,865
Messages
5,386,420
Members
401,997
Latest member
cizwiz

Some videos you may like

This Week's Hot Topics

Top