Hi! I'm relatively new to Excel and am not sure if there is a way to easily complete what I'm trying to do.

I have survey data with agree/disagree answers. I made an example of what it looks like (b/c confidential data) (hopefully the upload works):

Screen Shot 2021-03-01 at 7.42.58 PM.png

I want to make a pivot table that has each question along the top column, strongly agree --> strongly disagree down the left row, and the number of people that answered strongly agree, agree, neutral, etc. for each question. As I add more questions into the field, I get the answers all mixed up together like this:
Screen Shot 2021-03-01 at 7.45.32 PM.png

I was wondering if anyone had an idea of how to create one pivot table with multiple answers lined up side by side for the same words like I'm trying to do, or any references where it has already been explained. The only thing I could think of was to create individual pivot tables and then copy them and line them up manually, but I'd like to know if there was a way to group them together in order to make one pivot chart.

Thank you, I appreciate any help anyone can offer!