Help with organizing data for chart

[Anonymous]

Hi ,

I have a dataset with a row for every person. These people have answered multiple questions about if a certain aspect of a location is good, sufficient, insufficient, etc. What i want is a barchart with these ratings for all these questions at once.  The way my data is organised now it doesn't seem possible, but i'm sure i can transform it one way or the other so that it will be. 

Earlier i had another - maybe similar - problem. People answered a question for their first sport and one for their second sport. It was the same question. What i wanted then was almost the same: to put it in one chart, where i want to count both answers (if one person answers yes for sport one, and yes for sport two, it's two times yes). I managed to get to what I need by grouping and unpivoting, see code below. I am actually unsure if this is the way to go and if I can use this idea again for the problem i have now. 

#"Grouped Rows" = Table.Group(#"Filtered Rows", {"Opwelkemanierisjouwsportgeorganiseerd", "Opwelkemanierisjouwsportgeorganiseerd_A"}, {{"organisatie", each Table.RowCount(_), Int64.Type}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Grouped Rows", {"organisatie"}, "Attribute", "Value")
in
#"Unpivoted Columns"

Thanks for suggestions!

[amitchandak]

@Anonymous , What I think you need split by delimiter

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

If this does not help
Can you share sample data and sample output in table format?