Transforming sharepoint list survey results

[Jaydis]

Hi,

I am anaylzing results from a survey which are pulled into power bi through a sharepoint list. The format of the sharepoint list is as follows:

I would like to graph the results on a stacked bar chart - yaxis being the questions and xaxis being the % answered of each type (Excellent, good, fair, poor, n/a), also being able to filter by project #, date, manager.

I believe the easiest way to do that would be to get my data in the following format:

How would I use power bi to transform the data this way? (Or is there a better way to format the data to get the resultant graph?) 

Thanks so much!

[MarkLaf · Accepted solution]

In query editor, select Q1, Q2, Q3 columns, right click, and click 'Unpivot Only Selected Columns':

[Anonymous]

When selecting unpivot only selected columns, all the columns display "error". 

The error message is:

DataSource.Error: We couldn't parse OData response result. Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value.
Details:
DataSourceKind=SharePoint
DataSourcePath=https://mytentnat.sharepoint.com/sites/qa/_api/Web/Lists(guid'542c4b4b-f41d-472b-a401-8e0768adc2d8')...