title: Problem grouping rows into columns in Power BI
body: <p>I am working on a dashboard. I have a data source that contains a column with values ​​separated by commas. I am trying to group rows using these columns. Yet,
  Values ​​are not classified by default. That way, I can have something like this:</p>
  <pre><code>Line 1 - A, B, C
  Line 2 - C, B, A
  Line 3 - A
  Line 4 - B, C
  Line 5 - C, B
  Line 6 - A
  </code></pre>
  <p>What I want to achieve is a grouping like this:</p>
  <pre><code>A, B, C - Line 1 and Line 2
  A - line 3 and line 6
  B, C - line 4 and line 5
  </code></pre>
  <p>I thought about dividing the CSV into columns, classifying them and finally joining them again as CSV, but I'm not sure how to proceed.</p>