Pivot Table Filter For Multiple Survey Responses

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,406
you will need PowerQuery aka Get&Transform

use Data tab, select whole source table, then on the ribbon From Table, it will open PQ Editor, select all Q columns, from the PQ Editor ribbon choose Unpivot only selected columns, then Close& Load to.., choose Only Create Connection, OK.

next Insert - Pivot Table - Use External data source - select Query Table, choose target place

next you can do what you want

example
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,099,600
Messages
5,469,630
Members
406,661
Latest member
west5405

This Week's Hot Topics

Top