Pivot Tables in MS Excel Office 365

0 votes

I've created an excel spreadsheet with the results of a survey I performed. Responses to seven distinct questions are tracked. There are 5 possible answers for each question: not at all, barely, moderately, very, and tremendously.

I am attempting to use Pivot Table to generate a table that will tally the amount of values for each of the five different sorts of responses across seven different questions, but I am unable to do so.

Input table:

Data on which Pivot Table is built

Desired output table: enter image description here

The problem is that count values of Q1 get copied in columns for Q2, Q3, Q4, and so on. If I drag Q2, Q3, Q4 in rows of the pivot table field then it begins to separate the responses of each type, creating a big mess e.g. shown below:

enter image description here

Nov 13 in Others by Kithuzzz
• 20,660 points
36 views

1 answer to this question.

0 votes
If you create the required result table and just use the countif() function on the data to get the required result.
answered Nov 13 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
251 views
0 votes
1 answer

Export HTML Table to Excel- Doesn't Open in Office 2010

We had the same issue too many ...READ MORE

answered Oct 21 in Others by narikkadan
• 37,660 points
59 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
43 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6 in Others by narikkadan
• 37,660 points
33 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
81 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
53 views
0 votes
1 answer

Can I use VBA in Excel 2010 Starter Edition?

No, unfortunately you can't use VBA in ...READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
60 views
0 votes
1 answer

Opening Selected Hyperlink DISPLAYING TEXT in Default Browser in MS Excel

Try this code: Sub Open_SelectedTextlinks() If Not ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer

Statistical Kurtosis in relation to SPSS and MS excel

Kurtosis does not measure "peakedness" or "height" ...READ MORE

answered Oct 20 in Others by narikkadan
• 37,660 points
38 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP