title: Splitting List<T> based on comma separated property value using Linq
body: <p>Given this class:</p>
  
  <pre><code>public class Article
  {
     public string Name { get; set; }
     public string Colour { get; set; }
  }
  </code></pre>
  
  <p>Suppose I have the following <code>List&lt;Article&gt;</code> where some of the articles contain a comma separated name:</p>
  
  <pre><code>var list = new List&lt;Article&gt; 
  {
      new Article { Name = "Article1, Article2, Article3", Colour = "Red" },
      new Article { Name = "Article4, Article5, Article6", Colour = "Blue" },
  }
  </code></pre>
  
  <p>Is there a way, in one <code>Linq</code> statement, to get a list where each comma separated name becomes a separate article?</p>
  
  <pre><code>var list = new List&lt;Article&gt; 
  {
      new Article { Name = "Article1", Colour = "Red" },
      new Article { Name = "Article2", Colour = "Red" },
      new Article { Name = "Article3", Colour = "Red" },
      new Article { Name = "Article4", Colour = "Blue" },
      new Article { Name = "Article5", Colour = "Blue" },
      new Article { Name = "Article6", Colour = "Blue" },
  }
  </code></pre>