Organizing survey data into one pivot

Hi all,

I have attached a spreadsheet of data containing survey questions. The survey asks respondents a number of questions to gauge their retirement readiness and confidence in health and finance. There are preliminary questions for age, marital status, and retirement timeline. The end goal is to organize these responses in a way that allows me to break down the responses based on the prelim questions (ex: divorced people 5 years out from retiring are confident with x but not confident with y).

I have included a screenshot of an early version of this in google sheets, in which I have a pivot table for each question. The issue is that there are 45+ questions, so this is totally inefficient. Is there a way to include all question responses in one pivot that also allows me to break things down based on the prelim questions? I tried using power query and power pivot, but at this point I'm wondering if it's easier or makes more sense to just use filters for the prelim questions.

Any help is appreciated, happy to clarify anything.