Tying Particular rows with data to other rows to show in Matrix

[dbrandone]

I am building a report for a department who is wanting to pull data from Microsoft Forms. The data is from surveys on satisfaction. Because of the way that Forms data has each question as a column, plus each of the surveys in this case, have comment open text afterwards, I had to pivot the tables to place all questions and comments in one column. This has helped for filtering to drill down in the data. I have everything organized but need a way to have the questions and then the subsequent comment show side by side in a matrix along with other data for that specific question. The questions along with comment question are in a "Question" column and the answers are in a seperate column. 

Prior to pivoting the table, I renamed all of the comment questions to a name tied to the original question since all of the comment questions said the same thing. 

Question	Answer
The service was great?	Strongly Agree
Service Comment	Jane Doe was great at helping us
The product I received was great?	Somewhat Agree

In the example above I need the service comment (from answer column) to be next to the Service Question in a matrix visual.  

[AllisonKennedy]

@dbrandone  I'm not sure about Pivoting the data here - generally we want it Unpivoted, but agree Microsoft Forms doesn't put data in the ideal Power BI format: 

https://www.youtube.com/watch?v=UAjAtbN1MAY&feature=youtu.be 

You may need to add in one additional table that includes the Question and the Group, ie: 

Question	Group	Type
The service was great?	Service	Likert
Service Comment	Service	Free Text
The product I received was great?	Product	Likert
Product Comment	Product	Free Text

Then you can use that information to pivot and put the comment next to the question.