Pivot Table Filter For Multiple Survey Responses

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,292
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
 

Forum statistics

Threads
1,078,252
Messages
5,339,097
Members
399,277
Latest member
Jyoti C

Some videos you may like

This Week's Hot Topics

Top