0

Say I have a basic table of data with 1 question asked twice (once before, once after to compare responses).

Question 1: Before Question 1: After
WRONG CORRECT
CORRECT CORRECT
WRONG CORRECT

I do a pivot table on this data and i get:

enter image description here

enter image description here

However, I want to combine the Rows, so it looks like:

enter image description here

Improve this question
2
  • Load your source table to Power Query, highlight both columns and then use the Unpivot Columns feature within the Transform ribbon. You can then create your desired Pivot Table from this new table quite easily. Commented Mar 23, 2023 at 13:24
  • The ooutput you want is not possible using only Pivot Tables. You need to use PowerQuery or manually construct your headers and first column and then use COUNTIFS to get desired output Commented Mar 23, 2023 at 13:55
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
454
Using Pandas to pd.read_excel() for multiple (but not all) worksheets of the same workbook without reloading the whole file
141
Simple Pivot Table to Count Unique Values
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.