title: Concatenating results from many if statements into a new column [Power Query]
body: <p>I have a column "Group Membership" that contains many tags. I want to search to see if a tag is mentioned in this column or not. If yes, I want to add it to a list separated by a comma in a new column.</p>
  
  <p>I got started with this:</p>
  
  <pre><code>let
  
  ...
  
      #"Added Conditional Column" = Table.AddColumn(#"Moved Prefix", "Custom", each 
    if (Text.Contains([Group Membership], "Japanese Language") then "Japanese, " else null) &amp;
    if (Text.Contains([Group Membership], "English Language") then "English, " else null) &amp;
  
  ...
  
  )
  
  in
      #"Added Conditional Column"
  </code></pre>
  
  <p>But the syntax seems wrong. Can somebody help me?</p>
  
  <p>Thanks!</p>