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

jkstallard
  • 375
  • 1
  • 2
  • 17
  • 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. – Jos Woolley Mar 23 '23 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 – Foxfire And Burns And Burns Mar 23 '23 at 13:55

0 Answers0