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, 2022 in Others by Kithuzzz
• 38,010 points
521 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, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

Filter only certain columns in Excel Pivot Tables

Pivot Tables are mainly designed to create aggregated data from ...READ MORE

answered Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
272 views
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, 2022 in Others by gaurav
• 23,260 points
3,223 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, 2022 in Others by narikkadan
• 63,700 points
602 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, 2022 in Others by narikkadan
• 63,700 points
430 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,670 points
277 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, 2022 in Others by narikkadan
• 63,700 points
422 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, 2022 in Others by narikkadan
• 63,700 points
352 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, 2022 in Others by narikkadan
• 63,700 points
513 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, 2022 in Others by narikkadan
• 63,700 points
551 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, 2022 in Others by narikkadan
• 63,700 points
371 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