Hi there,

I have survey results that I am trying to pivot. the problem is that the results to all of my qualitative questions are broken out into multiple columns per question, with binary data in each row. I want to be able to chart all responses to a single question, but creating multiple pivot tables will take too long (I have 50+ different questions)

Here's an example:
Excel_Help_.PNG

Any ideas?

Thanks