I'm trying to use pivot tables to summarize data from a survey. Unfortunately the survey produces raw data that appears to be extremely unfriendly for use with pivot tables. I've attached a spreadsheet with a few questions, with the raw data in one tab and the tables in a second tab.

Q1 is easy to report with a pivot table, however, Q2 is a multiple choice question with nonexclusive options, so each option is considered a sub-question with a yes/no answer to indicate whether it was selected. You can see I created the format of the table I'm looking for with just manual copy/paste and some formulas, however I'd like to be able to create this with a pivot table instead. Does anyone know if this is possible?

Any help or nudges in the right direction would be greatly appreciated. I haven't had any success searching for the answer, but I might just not know the right terminology to search with.

Here is the spreadsheet:
jl_survey_data_12-05.xls

Thanks!
-Jeff