Group results in power bi by columns containing string values

[terezasteflova]

Hi all, 

I have a question regarding possibility to count string values for more columns and show it as a sum in stacked bar chart. 

I have around 20 questions, with aswers such as "beginner", "pragmatist" etc. I need to visualise the sum of the results for area of questions, eg. Q1 - Q5, but not to loose the information from the rows. 

This is an example of the data:

I need to show it like this:

However, not only for the Q1 but for the summary of Q1 - Q5 etc. 

Do you have any idea (easy) how to do that?

Thank you very much for your help!!!

Tereza

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.